Excel comments not displaying

Anonymous
2017-01-22T11:53:30+00:00

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.

Microsoft 365 and Office | Excel | For home | Windows

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.

0 comments No comments

57 answers

Sort by: Newest
  1. Anonymous
    2018-01-23T16:08:45+00:00

    Fix for Excel 2016 Comments Not Displaying on MacOS 

    Configuration -- Running Excel 2016 Version 16.9 (180116) on MacOS High Sierra 10.13.2.

    Situation -- Excel Auto Updater ran on 1/18/2018 and from that moment onward I had trouble with comments displaying when rolling the cursor over a commented cell.  As stated above, it would work for a while, and then simply stop working after 10-15 min and the only fix was to Quit and restart Excel.

    What Worked -- I shut down Excel and dragged the folder named "com.microsoft.Excel" from the Library>Containers folder to the Trash.  

    Pathname of Folder to Delete -- Macintosh HD>Users>user_name>Library>Containers>com.microsoft.Excel

    I then restarted Excel and the problem appears to be gone.  The deleted folder is automatically recreated by Excel.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  2. Anonymous
    2018-01-23T05:58:06+00:00

    Fix for Excel 2016 Comments Not Displaying on MacOS 

    Configuration -- Running Excel 2016 Version 16.9 (180116) on MacOS High Sierra 10.13.2.

    Situation -- Excel Auto Updater ran on 1/18/2018 and from that moment onward I had trouble with comments displaying when rolling the cursor over a commented cell.  As stated above, it would work for a while, and then simply stop working after 10-15 min and the only fix was to Quit and restart Excel.

    What Worked -- I shut down Excel and dragged the folder named "com.microsoft.Excel" from the Library>Containers folder to the Trash.  

    Pathname of Folder to Delete -- Macintosh HD>Users>user_name>Library>Containers>com.microsoft.Excel

    I then restarted Excel and the problem appears to be gone.  The deleted folder is automatically recreated by Excel.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  3. Anonymous
    2018-01-19T16:43:48+00:00

    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.

    Was this answer helpful?

    10+ people found this answer helpful.
    0 comments No comments
  4. Anonymous
    2018-01-19T16:05:36+00:00

    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. 

    Was this answer helpful?

    8 people found this answer helpful.
    0 comments No comments
  5. Anonymous
    2018-01-19T07:50:31+00:00

    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.

    Was this answer helpful?

    0 comments No comments