Comments In Excel Not Appearing

by | Feb 13, 2020 | Software | 0 comments

There was a time when Excel only had a “Notes” feature where one can insert a note in any cell. Well, at some point, they added a “Comments” feature, which allows people to have discussions in any cell. Comments are threaded, timestamped, and authored accordingly. Its a neat feature, and was introduced sometime around when Office 365 subscription came about. The following links help explain more on the Comments feature in Excel:

  1. The difference between threaded comments and notes
  2. Threaded comments

  3. Threaded Comments in Excel

Problem

There was some confusion based on my experience. I remember wondering why I had both the Comments and Notes feature at the office, but then on my personal computer only had the notes feature? Why? They were the same version of Excel, and I could not figure out why there were differences. I would write Comments in an excel file at the office but then would not see the Comments when I opened the same excel file at home on my personal computer. There’s a simple, yet annoying, explanation to this anomaly. The license I carried at home is a perpetual license and the license at the office is an Office 365 subscription license. The perpetual license doesn’t allow for commenting. I think this is a significant difference that should be made clear in the product comparison page between Office 365 and Office Home and Student licenses, but it’s not. You might have to dig deep to find that information.

Solution

Don’t use Comments at all and stick to Notes instead, or switch from a Retail License (perpetual) to an Office 365 License (subscription) to unlock the Comments feature. The latter costing you more in the long run.

Conclusion

I think it’s a complete ripoff only to include the Comments feature in Office 365 and not in the Retail License. I hope this story, rant, and suggestion to a solution helps others in a similar situation or at least shed some light on the matter.

Bill Paxton Tribute

Bill Paxton dies at 61.

Aerial Project “33K”

Aerial view of Mother Nature shot on RED in 8K

God: City

God: City is yet another dark-humor short film from Oats Studios which is a follow up to God: Serengeti.

Opening .dwg Files in Mac

I know we can open .dwg files in ArchiCAD... but what if you just needed to open a .dwg file quickly without having to launch the almighty ArchiCAD or perhaps checking how your .dwg file might look like to consultants using AutoCAD after exporting. Maybe you want to...

You Can Still Buy A New DeLorean

The DeLorean. Clean and timeless design. Stainless steel.

9 Composition Photography Tips From Steve McCurry

Awesome composition photography tips!

Dawn of Fire

Lava is molten rock generated by geothermal energy and expelled through fractures in planetary crust or in an eruption, usually at temperatures from 700 to 1,200 °C (1,292 to 2,192 °F). “Dawn of Fire” captures amazing footage of flowing lava.

The Red Turtle (2016) Official Trailer

A massive sea turtle destroys a stranded man’s raft every time he tries to sail away from a tropical island. – Moviefone

Remembering Sam Shepard: 1945-2017

Sam Shepard moves on.

How To Pronounce Korean Names

Being a kdrama fan (My wife talked me into Coffee Prince and the rest was history), I thought this was an intersesting read: http://beyondhallyu.com/culture/korean-names-and-how-to-pronounce-them/ Watching this tutorial video by sweetandtastyTV also helped...