We use Sharepoint 2007 site to share Excel 2003 file with Clients. We have a Few cells in the Excel file which have comments attached. When we check-in the file, the comments still Exist. If we check out the file the comments still Exist. But when a few clients check out the file, the Comments dis-appear.
I am sorry I cannot be anymore specific as its an intermittent issue. Sometimes it happens and sometimes it doesnt. We are all using Office 2007 on Windows XP and the file is hosted on Sharepoint 2007 site.
PS. There are 3 Worksheets in the Excel file and the 1st worksheet which has the comments is password protected. The password is not shared and there is no easy way or a reason for the users/clients to delete the Comments.
View Complete Post