Solved

Excel Comments Deleting

Posted on 2014-03-18
3
189 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

The Windows functions GetTickCount and timeGetTime retrieve the number of milliseconds since the system was started. However, the value is stored in a DWORD, which means that it wraps around to zero every 49.7 days. This article shows how to solve t…
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

622 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