Cannot Edit Notes in MS Excel for Mac

%3CLINGO-SUB%20id%3D%22lingo-sub-1960468%22%20slang%3D%22en-US%22%3ECannot%20Edit%20Notes%20in%20MS%20Excel%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1960468%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20morning.%20%26nbsp%3BI%20am%20running%20version%2016.43%20of%20MS%20Excel%20for%20Mac%20(Office%20365).%20%26nbsp%3BI%20have%20a%20spreadsheet%20I%20have%20been%20using%20for%20around%2020%20years.%20%26nbsp%3BIn%20the%20spreadsheet%20I%20insert%20Notes%20on%20certain%20cells.%20%26nbsp%3BIn%20the%20past%20when%20I%20wanted%20to%20edit%20a%20note%20I%20have%20always%20used%20right-click%20then%20%22Edit%20Note%22%20and%20this%20has%20always%20worked%20correctly.%20%26nbsp%3BA%20week%20or%20two%20ago%20it%20stopped%20working.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20read%20on%20several%20message%20boards%20and%20tried%20to%20resolve%20the%20problem.%20%26nbsp%3BHave%20copy-pasted%20the%20whole%20sheet%20into%20a%20new%20workbook.%20%26nbsp%3BThe%20problem%20persisted.%20%26nbsp%3BHave%20saved%20as%20.xls%20instead%20of%20.xlsx.%20%26nbsp%3BThe%20problem%20persisted.%20%26nbsp%3BUsed%20the%20Review%20tab%20and%20tried%20to%20Edit%20Note%20that%20way.%20%26nbsp%3BThe%20problem%20persisted.%20%26nbsp%3BI%20increased%20the%20column%20width.%20%26nbsp%3BThe%20problem%20persisted.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20checked%2C%20and%20other%20sheets%20in%20the%20same%20workbook%20have%20notes%20and%20I%20can%20edit%20them%20normally.%20%26nbsp%3BAlso%20in%20other%20workbooks.%20%26nbsp%3BThis%20particular%20sheet%20is%20the%20only%20one%20with%20the%20problem%2C%20but%20it%20has%20many%20notes%20and%20they%20are%20important%20to%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%20for%20your%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1960468%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1961532%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20Edit%20Notes%20in%20MS%20Excel%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1961532%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F892625%22%20target%3D%22_blank%22%3E%40ndylanray%3C%2FA%3E%26nbsp%3BPerhaps%20you%20accidentally%20protected%20the%20sheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1961845%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20Edit%20Notes%20in%20MS%20Excel%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1961845%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%2C%20thank%20you%20for%20your%20help%2C%20but%20the%20sheet%20is%20not%20protected%20nor%20the%20workbook.%20%26nbsp%3BI%20can%20delete%20entire%20worksheets%2C%20delete%20contents%20of%20cells%2C%20add%20new%20notes%2C%20delete%20notes%2C%2C%20etc.%20%26nbsp%3BI%20just%20cannot%20edit%20existing%20notes.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Good morning.  I am running version 16.43 of MS Excel for Mac (Office 365).  I have a spreadsheet I have been using for around 20 years.  In the spreadsheet I insert Notes on certain cells.  In the past when I wanted to edit a note I have always used right-click then "Edit Note" and this has always worked correctly.  A week or two ago it stopped working.

 

I have read on several message boards and tried to resolve the problem.  Have copy-pasted the whole sheet into a new workbook.  The problem persisted.  Have saved as .xls instead of .xlsx.  The problem persisted.  Used the Review tab and tried to Edit Note that way.  The problem persisted.  I increased the column width.  The problem persisted.

 

I checked, and other sheets in the same workbook have notes and I can edit them normally.  Also in other workbooks.  This particular sheet is the only one with the problem, but it has many notes and they are important to me.

 

Thank you in advance for your help.

 

 

5 Replies

@ndylanray Perhaps you accidentally protected the sheet.

@Riny_van_Eekelen , thank you for your help, but the sheet is not protected nor the workbook.  I can delete entire worksheets, delete contents of cells, add new notes, delete notes,, etc.  I just cannot edit existing notes.

@ndylanray Can't find any setting that would affect only notes in a particular sheet. Perhaps a bug in a recent update. You can send feedback to MS. 

Screenshot 2020-12-07 at 11.04.22.png

@ndylanray did you get resolution to this? I have just had the exact thing happen with a spreadsheet I have been using for years with many notes also...

The only way I managed to go around this problem was:

1. Import file Excel to GoogleSheets,

2. Select all cells

3. Edit > Clear Notes 

4. Export file with .xlsx extension

In my case, all formatting was preserved. I hope it helps. 

(Clearly, something needs to be done to correct this)

 

Office 365

Excel on Mac

 

@ndylanray