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.

Wonders of Yangshuo

Daan van Reijn captures Yangshuo beautifully!

Gdansk

Oats Studios just got medieval on fans!

Should I Mix Different Types Of Batteries?

The short answer is no. If you have kids, you most likely will have a bunch of battery-operated toys. AA batteries will probably be the most common batteries for these toys. There are many types available such as Alkaline, Lithium, NiMH, NiZN, and NiCD batteries. I've...

Gestational Diabetes

It’s not as bad as it sounds.

Volume 1 – Firebase

Set in the Vietnam War, Neill Blomkamp’s Firebase is nothing less of frightening.

Volume 1 – Rakka

Watch Rakka, the first short film from Oats Studios.

Stock Watch 2016-12-18

Yahoo! Inc. ➡️ Yahoo says one billion accounts exposed in newly discovered security breach Yahoo shares fall after security breach, under Federal probe Yahoo had its holiday party inside its offices, and it was the opposite of last year’s lavish...

Envisioning Chemistry: Chemical Garden II

The growth of insoluble membranes have never looked this good!

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…

Meet The Dock

A new way to go surfing.