Excel Comments not displaying properly

Question

Hi I use a MacOS  version :High Sierra 10.13.3. I recently upgraded my Excel for Mac and have version 16.9.  For some reason all the Comments I have previously written on Excel spreadsheets when I view them they come up as code and don't display in words. How do I fix this  as I need to read these comments in words not computer code? THANK YOU

Answer 1

Hi Maree,

For troubleshooting purpose, I use Excel for Windows to check the two .xls workbooks you provided.

Here’s the result:

For the workbook having no issue, when I go to File > Check for Issues > Check compatibility, it shows “no compatibility issues were found”.

For the workbook having the messy code issue. It shows that “Some cells or styles in this workbook contain formatting that is not supported by the selected file format. These formats will be converted to the closest format available”.

I notice that the two workbooks are all .xls format. Have they ever been converted from another format to .xls? Are there any specific format or styles used in the spreadsheet? But these are all the things I am thinking of the cause of the issue. It seems that the spreadsheet has been damaged for some reason. There may not be easy to repair them. So, how can you get the work well spreadsheet back? If you have any copy of them from your colleagues or organization server, can you get all them back?

Thanks,

Rena

Answer 2

I would try version 16.10 or 16.11. You get these by joining the Insider program.

16.10 is Insider Slow. Start with that one.

What is Office Insider? - Office Support

Answer 3

Hi Maree,

How is everything going? Have you tried any steps above after your travel?

Thanks,

Rena

Answer 4

HI Rena

I'm sorry but I have not been in good internet service to try the options due to still travelling on a boat.

I should be back on land and with good internet  mid next week.

If you have not herd from  me by next Wednesday 21st  please check back in with me.

thank you for your patience 

☺️cheers maree

Answer 5

Thanks Jim I'll looking once back on land next week. ☺️cheers maree