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.

The Marshmellow Test and Thoughts by Michio Kaku

Interesting ideas and thoughts by physicist Michio Kaku related to success and intelligence.

Garbage – No Gods No Masters (Official Music Video)

Garbage nails it again - always! The instrumentals on this particular track remind me of the 90s with a dash of 80s vibe thrown in, and I love it. Shirley delivers in all of her lyrical glory. Here’s the official video of the title track from Garbage’s forthcoming...

Grace VanderWaal

Every once in awhile - someone will standout in America’s Got Talent. And this year it’s Grace VanderWaal performing an original for her first audition - “I Don’t Know My Name.” on June 7, 2016Then she sings yet another original “Beautiful Thing” on August 23, 2013 On...

Help Stop Cubbing In Colorado

The Star Wars: Concept Trailer

What might have been, had the original Star Wars concept art and script made it to the final cut?

Earth Hour 2017

“WWF’s Earth Hour shows us how each of us can be heroes for our planet, our home.” – Earth Hour 2017

Odd News 2016-09-07

From political birthday cakes to snakes fighting on rooftops - here are this week’s odd news:Teen Cries Foul After Bakery Refuses To Make ‘Trump 2016’ Birthday CakeProbation for Ohio man accused of egging home 100-plus timesExtra crispy bacon, ribs: Truck carrying...

Wanderers

A short film by Erik Wernquist written and narrated by Carl Sagan with an inspiring message

Wonders of Yangshuo

Daan van Reijn captures Yangshuo beautifully!

Stop Lorry Attacks

The attack in Nice and Berlin in 2016 has been horrific and the latest methods in striking terror. When the 9/11 attacks happened, we tightened security to prevent future hijackings. The truck attacks are a little more complex to counter because anyone can access a...