Forum Discussion
no longer able to add comments to cells
What seems to have solved the problem is to STOP sharing the worksheet with someone who is using it in excel online. There were a host of problems with conditional formatting, notes, comments, etc. The other issue that kept happening was when my co-worker would open it in excel online, it would become an older version when it saved to the shared drive. I have had zero problems since I stopped having her do updates in on-line.
NikolinoDE I had this exact same problem for the first time today. All my other spreadsheets worked fine - just the one had the problem. I even tried opening it on another laptop and it still wouldn't let me add comments. I wondered if there was a dodgy calc somewhere in the workbook, so I took a punt and selected every sheet in the workbook (15 tabs) and then pressed Calculate Sheet and voila comments worked again!
Anthony_E_Miller This worked for me. I hope I can remember it when it occurs again. I do recall this happening a few years ago and it "magically" recovered at some point. Very frustrating.
