Solved

Excel Comments Deleting

Posted on 2014-03-18
3
182 Views
Last Modified: 2014-04-08
Hi,

I am having an issue with one of my customers shared excel document. There is around 4 people that use the document, three use excel 2007 & one uses excel 2010. What happens is, they regularly add comments to cells in the document then save it & then when they re-open it, some of the comments have disappeared completely. At first I though it could be an issue with it being a shared file and when another person saves, it overwrites changes, however the data that has been inputted in the cell is still there, just some comments go missing.

Any ideas would be appreciated.

Regards
0
Comment
Question by:erudit
3 Comments
 
LVL 39

Expert Comment

by:nutsch
ID: 39936943
Sadly, shared excel workbooks are notoriously unreliable and are to be avoided as the plague. I don't know about your specific issue, but I think it's par for the course with shared workbooks.

Check the sheet protection settings, check if it's just the comment indicator missing rather than the comment (Tools \ Options)

See this forum post for a lot of people having that issue:

Thomas
0
 
LVL 2

Accepted Solution

by:
bearblack earned 500 total points
ID: 39937107
I have found that if the users use save as and save it with the same file name shared files seem to work much better, not perfect but more reliable than just click save.
0
 

Author Comment

by:erudit
ID: 39939142
I have checked the sheet protection settings & they are set correctly.

I will advise using save as instead of the standard save feature and see if things improve.

Any other suggestions?
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
When you try to share a printer , you may receive one of the following error messages. Error message when you use the Add Printer Wizard to share a printer: Windows could not share your printer. Operation could not be completed (Error 0x000006…
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question