Home

notes attached to cells not visible, broken since last excel update (Office 365 on Mac)

%3CLINGO-SUB%20id%3D%22lingo-sub-327815%22%20slang%3D%22en-US%22%3Enotes%20attached%20to%20cells%20not%20visible%2C%20broken%20since%20last%20excel%20update%20(Office%20365%20on%20Mac)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-327815%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20got%20many%20notes%20(the%20yellow%20non-threaded%20formerly%20called%20comments)%20in%20my%20excel%20sheets.%20Since%20the%20latest%20software%20update%20I%20can%20not%20display%2Fview%20my%20notes%20anymore.%3C%2FP%3E%3CP%3EThe%20cells%20containing%20note%20still%20show%20the%20red%20triangle-mark%2C%20but%20the%20note%20does%20not%20show%20up%20when%20I%20mouse%20over.%20By%20clicking%20%22show%20all%20notes%22%20in%20the%20ribbon%20menu%2C%20it%20will%20just%20only%20show%20the%20connection%20lines%20between%20cell%20and%20invisible%20note%20rectangle.%20But%20I%20can%20not%20access%20view%20or%20even%20edit%20the%20notes.%3C%2FP%3E%3CP%3EAlso%20right%20click%20on%20the%20cell%20-%26gt%3B%20edit%20note%20does%20not%20show%20anything.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eis%20there%20a%20fix%20or%20at%20least%20a%20workaround%20existing%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eregards%3C%2FP%3E%3CP%3Edewege%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Emacos%3A%20high%20sierra%2C%3C%2FP%3E%3CP%3Eexcel%20(office%20365)%20version%2016.21.1%20(190123)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-327815%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EComments%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENotes%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-363813%22%20slang%3D%22en-US%22%3ERe%3A%20notes%20attached%20to%20cells%20not%20visible%2C%20broken%20since%20last%20excel%20update%20(Office%20365%20on%20Mac)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-363813%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20faced%20this%20problem%20recently.%3C%2FP%3E%3CP%3EOnly%20%22Delete%20Note%22%20option%20is%20available%20in%20context%20menu.%3C%2FP%3E%3CP%3EIf%20you%20want%20to%20add%20a%20new%20note%2C%20please%20go%20to%20the%20Review%20menu%2C%20the%20Note%20option%20is%20listed%20there.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-332422%22%20slang%3D%22en-US%22%3ERe%3A%20notes%20attached%20to%20cells%20not%20visible%2C%20broken%20since%20last%20excel%20update%20(Office%20365%20on%20Mac)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-332422%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20same%20issue.%26nbsp%3B%20It%20looks%20like%20MS%20was%20nudging%20users%20off%20the%20old%20yellow%20notes%20feature%20(which%20I%20use%20a%20LOT)%20toward%20the%20%22comments%22%20side-bar%20approach.%26nbsp%3B%20I%20hate%20it%20when%20developers%20get%20a%20%22good%20idea%22%20and%20force%20us%20to%20change%2C%20especially%20with%20no%20notice%20or%20transition%20support.%26nbsp%3B%20This%20is%20a%20HUGE%20pain.%26nbsp%3B%20But%2C%20will%20MS%20notice%3F%26nbsp%3B%20I%20doubt%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-331505%22%20slang%3D%22en-US%22%3ERe%3A%20notes%20attached%20to%20cells%20not%20visible%2C%20broken%20since%20last%20excel%20update%20(Office%20365%20on%20Mac)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-331505%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20just%20discovered%20the%20same%20issue.%26nbsp%3B%20No%20option%20to%20add%20or%20edit%20notes%20either%20...%20only%20comments%20(which%20I%20don't%20need).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-874898%22%20slang%3D%22en-US%22%3ERe%3A%20notes%20attached%20to%20cells%20not%20visible%2C%20broken%20since%20last%20excel%20update%20(Office%20365%20on%20Mac)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-874898%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F274752%22%20target%3D%22_blank%22%3E%40dewege%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20had%20this%20problem%20too.%26nbsp%3B%20What%20I%20found%20worked%20was%20to%20copy%20the%20cell%20to%20a%20new%20tab.%26nbsp%3B%20The%20Note%20will%20show%20up%20there%20(though%20I%20had%20to%20move%20the%20frame%20buttons%20to%20make%20the%20square%20visible).%26nbsp%3B%20Then%20I%20copied%20the%20cell%20back%20to%20the%20original%20tab.%26nbsp%3B%20This%20fixed%20the%20issue%20for%20me.%26nbsp%3B%20Hope%20this%20helps.%3C%2FP%3E%3C%2FLINGO-BODY%3E
dewege
Occasional Visitor

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?

 

regards

dewege

 

macos: high sierra,

excel (office 365) version 16.21.1 (190123)

4 Replies
Highlighted

I have just discovered the same issue.  No option to add or edit notes either ... only comments (which I don't need).

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.

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.

@dewege 

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.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies