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.
The suggestion to build a VB script to resize the comment box is the only thing that has worked for me:
https://www.mrexcel.com/forum/excel-questions/246429-resizing-multiple-comments.html
Same with me. Now rollover on comments is working. 👍😊
HERE'S THE ANSWER, F I N A L L Y :-)
Office 365's latest updated version don't have this issue.
In other words, if you start a new file and start working on it - these problems don't occur.
However, there is a problem when you use your old files and try to open it with Office 365. There seems to be some compatible issues there.
After months of frustration, and working with right click and EDIT COMMENT, and having to switch tabs to get rid of the comments box ... I ended up with the file shutting down, each time I wanted to view the comment.
So, I chatted with a customer support. And after 2 hours of interacting with the seniors - we were able to find out the COMPATIBILITY ISSUE.
Basically, if you copy your old files where you have your comments stored and paste it on a new file, then the comments can be viewed as you hover over the cell as before.
If you don't do this, then apparently there is no solution offered by Microsoft.
So, I changed my files by copying them into a new file, and it works perfectly alright.
Yes, it's a pain and time consuming to copy and paste on to a new file - but it's a lot better after having lot of frustrations in trying to work with the old ones.
HOPE THIS HELPS GUYS.
HERE'S THE ANSWER, F I N A L L Y :-)
Office 365's latest updated version don't have this issue.
In other words, if you start a new file and start working on it - these problems don't occur.
However, there is a problem when you use your old files and try to open it with Office 365. There seems to be some compatible issues there.
After months of frustration, and working with right click and EDIT COMMENT, and having to switch tabs to get rid of the comments box ... I ended up with the file shutting down, each time I wanted to view the comment.
So, I chatted with a customer support. And after 2 hours of interacting with the seniors - we were able to find out the COMPATIBILITY ISSUE.
Basically, if you copy your old files where you have your comments stored and paste it on a new file, then the comments can be viewed as you hover over the cell as before.
If you don't do this, then apparently there is no solution offered by Microsoft.
So, I changed my files by copying them into a new file, and it works perfectly alright.
Yes, it's a pain and time consuming to copy and paste on to a new file - but it's a lot better after having lot of frustrations in trying to work with the old ones.
HOPE THIS HELPS GUYS.
Do not work for me. Tried to copy the all cell to a new file. The comment still show as a line.
did not work for me either