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.

F9 Official Trailer 2

The Fast and the Furious can keep it coming. While some other movies fail with over-the-top action sequences and impossible storylines, this particular movie franchise manages to do it well, and it works. F10 can have Vin Diesel going to the moon, and I’d still watch...

The Last Bastion

So my sister sends me this awesome Overwatch Animated Short. She knows I love Bastion. This animated short is titled “The Last Bastion” and all I have to say is well done Blizzard, well done.

Chappie’s Hack Scene

The ending scene of 2015’s Chappie.

File Managers For Mac

Great File Managers to add to your work flow in macOS.

Meet The New ilumi Smartbulb

The New ilumi. A Better Smartbulb.

How To Set The Default Email Client on Windows 7

There are many reasons why you’d want to do this… improving your workflow, seamless email functions within Windows and the programs you use…

3 Tips For DoorDash Drivers

Tips for beginners to make this gig a more pleasant and efficient experience.

You Can Still Buy A New DeLorean

The DeLorean. Clean and timeless design. Stainless steel.

A Tribute To Charmian Carr

Chairman Carr passed away on September 17, 2016. I will always remember the countless times I watched The Sound of Music with my parents and siblings in the living room during the 90s. Even though the movie was a classic at that time, I always had the feeling that it...

The Man You Are

Self reflection brings you back to source.