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.
I use a Mac, and MS Office 2016 - and I have same problems. Initially, it worked well, and then it stopped.
Each time to view the comment, you have to edit the comments, and then the dialog box doesn't close automatically.
I updated with the latest.
Tried using customer chat service, and that person tried to help, but when he had remote access, I tried on a new excel sheet, and it worked.
But the problem is I have sensitive information on my old excel sheet and that doesn't work.
What MS Office is trying to do, I have no idea.