Is it the comments that are missing or is it the comment indicators.
I just shared a workbook, inserted a comment, saved, and reopened
and the comment was there. Did you save your workbook.
Since there is no point to me sharing a workbook I have very limited
experience, other than to say I won't use the option and don't have to
share with anyone for any reason. My own experience into shared
workbooks for highlight chnages is in
Highlight, Change Highlighting
http://www.mvps.org/dmcritchie/excel/highlite.htm
and getting rid of it without restoring from a backup can be done with
Tools -- Share Workbook -- uncheck option
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"FILRichie" wrote in message ...
Hi,
I've recently been working in a shared workbook with up to four others users
and using the Insert Comment function. However, despite regularly saving the
changes, the bulk of my comments disappeared after I exited and re-entered
the spreadsheet. I'm led to believe that this can happen in shared workbooks
that contain a lot of data as the one in question does. Has anyone else
experienced this issue and/or know a solution to the problem?