01-30-2019 01:08 AM
01-30-2019 01:08 AM
I've got many notes (the yellow non-threaded formerly called comments) in my excel sheets. Since the latest software update I can not display/view my notes anymore.
The cells containing note still show the red triangle-mark, but the note does not show up when I mouse over. By clicking "show all notes" in the ribbon menu, it will just only show the connection lines between cell and invisible note rectangle. But I can not access view or even edit the notes.
Also right click on the cell -> edit note does not show anything.
is there a fix or at least a workaround existing?
macos: high sierra,
excel (office 365) version 16.21.1 (190123)
02-06-2019 01:35 AM
I have just discovered the same issue. No option to add or edit notes either ... only comments (which I don't need).
02-07-2019 09:00 AM
I have same issue. It looks like MS was nudging users off the old yellow notes feature (which I use a LOT) toward the "comments" side-bar approach. I hate it when developers get a "good idea" and force us to change, especially with no notice or transition support. This is a HUGE pain. But, will MS notice? I doubt it.
03-10-2019 12:36 AM
I have faced this problem recently.
Only "Delete Note" option is available in context menu.
If you want to add a new note, please go to the Review menu, the Note option is listed there.
09-25-2019 09:30 AM
I have had this problem too. What I found worked was to copy the cell to a new tab. The Note will show up there (though I had to move the frame buttons to make the square visible). Then I copied the cell back to the original tab. This fixed the issue for me. Hope this helps.
04-21-2020 01:33 PM
Update: I realize this is an old thread, but I 'Unhid' all the rows. After I did that, I was able to right click and edit the notes.
by Dennis_Gewillig on May 29, 2020
by JLK2004 on May 29, 2020
by cuong on May 27, 2020
by Ingeborg Hawighorst on May 13, 2020