Hi.
I have a spreadsheet that heavily uses notes (formerly comments) to comment on the data. At some stage in the past 3 months all the notes have changed to include the following at the start of each note:
======
ID#AAAAD-NYSMg
tc={3601F7CA-C9E9-42F1-929B-4F5ACFBAC8A8} (2019-12-01 23:06:40)
[Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
I assume this was caused due to a newer version of excel being used to open the document which is stored on dropbox.
How do I change the comments back to the way they were without all the extra info at the start? and how do I keep it that way? There are hundreds of comments with this issue so it would take days to change them all manually. And the ones I have tried to edit to remove the extra text have reverted back when the document is opened on someone elses computer.
Thanks for the help
