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.

A Fictive Flight Above Real Mars

Anaglyph images of Mars was 3D-processed to create panning clips that look stunning!

Can You Get A Stylist For A Kindle?

Emailed from a friend of mine. While reading questions directed towards users of the Kindle Paperwhite I came upon this question and answer which rose to the top of the list with nearly 1650 votes.. nearly 1600 over any other reviewers response.. Question Can you get...

Rogue One: A Star Wars Story Trailer “Trust” (2016)

Seeing the Imperial Walkers in action again gave me the chills. https://youtu.be/F7Op9q9BxDs

Will Ferrell USC Commencement Speech 2017

I will never get tired of Will Ferrell.

Disciplining Your Kids

Babies and toddlers are naturally curious. So it's wise to eliminate temptations and no-nos — items such as TVs and video equipment, stereos, jewelry, and especially cleaning supplies and medications should be kept well out of reach. When your crawling baby or roving...

Formula E Car vs Cheetah

What happens when a Formula E car and one of nature’s fastest animals go head-to-head? – ABB Formula E

Calling The United States From The United Kingdom

How to call the US from the UK.

Why One May Prefer A Shared Printer Instead of a Network Printer

The pros and cons of a shared printer but why would you want one given the right environment.

Jumping to the First or Last Item in Finder

When you have a Finder window open, and in a folder with several files, you can scroll and select, which is great if it’s a small list of files. Or if it’s a long list or maybe we’re faster using our keyboards, you can hit Option+Up Arrow or Option+Down Arrow to jump...

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…