This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have excel 2016, and the comments have been working fine. Just recently it does not display comments when I mouse over them. The show/hide command in the review tab is greyed out. I never had this problem before, and never had to see if the comment show/hide feature was active or not.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
I closed everything down and restarted excel. It's working now....
That was the trick is guess...
Not sure what caused it,but it's gone.
Thanks for the help!
The update that rolled out today 18-Jan-2018 has broken the rollover functionality. The behavior I see is similar to what is described, but also includes a loss of speed of any data entry response over time.
When a spreadsheet with comment is first opened you can rollover a cell with comment and see the comments. If you leave the spreadsheet open eventually this stops working, and at that point I seem to notice a delayed responsiveness to the app.
The failure to show a comment is not instantaneous. I timed this and after roughly 20 min the "display comments on rollover" stops working. Perhaps there is a memory leak that is filling up virtual memory, but I'll leave that to the coders.
The only fix is to Quit Excel and re-boot. I tried closing the file in question without Quitting Excel but that doesn't work. You have to Quit the app.
Excel Team -- Please repair this and return Excel to normal functionality as soon as possible.
Thanks faysalMCC, I checked the settings you provided, and the radio button was already selected. I de-selected it, and re-selected it, selected ok, and the situation is the same. I can read the comments when I RMB and select show/hide, but they are always visible. The mouse over functionality has always been working fine until I just noticed it this morning. Any other thoughts???
Some more information on the behavior of this problem. As I said I'm running Excel 2016 on a Mac.
Today I opened the Excel App but didn't open any file. Then I just let is stay open for a while. After 30 min I opened a file. The "display comments on rollover" function didn't work anywhere in the spreadsheet.
By Quitting Excel and reopening on the same file I could see the comments. After 10 min or so the functionality stopped working.
Excel Team -- When will you get this repaired? We use Excel to track a detailed delivery schedule for our services firm and there are comments everywhere, and they are constantly being updated. It is very inconvenient to always have to Quit and restart the app. Your prompt attention to this is appreciated.