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-19T04:36:24+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.

    Was this answer helpful?

    20+ people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2018-01-16T10:04:13+00:00

    I have similar problem. Some comments on the same file are visible and some others I see only the arrow and unable to edit.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments No comments
  3. Anonymous
    2017-12-31T01:21:14+00:00

    I have a similar problem. Was working on a spreadsheet and mid-session the comment feature changed. When I hover over a cell, instead of seeing the comment box I see an arrow and a line. No box. When I select to edit the comment, the long line extends up to the top of the document and the box is compressed. Once I edit the comment and return to the cell, the comment feature behaves normally, but only for that cell. If I add new data & comment, everything works fine. But for all of the data that was in my document prior to the "change", I find I have to edit all the comments one by one to fix it.

    Was this answer helpful?

    7 people found this answer helpful.
    0 comments No comments
  4. Anonymous
    2017-01-22T15:16:56+00:00

    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!

    Was this answer helpful?

    30+ people found this answer helpful.
    0 comments No comments
  5. Anonymous
    2017-01-22T14:47:51+00:00

    Can you please provide a snapshot?

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments No comments