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 have similar problem. Some comments on the same file are visible and some others I see only the arrow and unable to edit.
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 a lot. Unfortunately the problem persists. In the same excel sheet, some comments are displaced normally and some others with only a line but without the comment box.
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.
For the record I’m running 2016 Exel on a Mac.
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.