SodaAddict
New Member
- Joined
- Jul 4, 2008
- Messages
- 4
Hello,
At my office, we are running a shared Excel 2007 worksheet across about 9 computers on our local network. We use this worksheet as our data validation process and frequently update cells with a simple code, highlight, and comment for ease of use.
After using this worksheet for over a month, it apparently decided not to save most of the comments that were made on Friday (although it randomly saved some of them for some users). I realize the missing comments are probably gone.
I did some searching here as well as generally on Google and other forums, and found that it looked like some other people had this problem, but I did not find a solution that seemed like it applied to our situation.
In addition to this, I have been using the change tracking to keep up with what has been changed and to make sure that the various users are not making any major errors such as changing information in wrong rows, removing stuff by accident without realizing it, etc. But today when I loaded up the change tracker in a separate sheet, I noticed there were large gaps in the "Action Number" column. I compared this to data that had been entered on Friday and noticed that a lot of the information that was changed was not showing up as changed at all. It was just there (without comments, in most cases). I do not know if the two issues are related or not, but I thought it was worth mentioning.
And yes, I did make sure that I had it highlight all changes made by everyone throughout the last 30 days. It shows changes throughout the day, but the ones that show up are randomly dispersed throughout the day and for different users.
The disappearing comments happened to more than just one user as well. Out of the 4 users who made changes to the sheet Friday, 3 of them lost most of the comments made. 1 person's comments appear unaffected. That person also saved her information at some point in the middle of when other information was saved as she left after some and before others whose comments were lost.
TL;DR -
Shared Excel 2007 Document
Comments Disappearing for the First Time in Almost 2 Months
Change History/Tracking Not Showing Some Changes That it Should Be
Appears Not to be User Exclusive Problem
Any help is greatly appreciated.
Thank you for your time,
Chris (SodaAddict)
At my office, we are running a shared Excel 2007 worksheet across about 9 computers on our local network. We use this worksheet as our data validation process and frequently update cells with a simple code, highlight, and comment for ease of use.
After using this worksheet for over a month, it apparently decided not to save most of the comments that were made on Friday (although it randomly saved some of them for some users). I realize the missing comments are probably gone.
I did some searching here as well as generally on Google and other forums, and found that it looked like some other people had this problem, but I did not find a solution that seemed like it applied to our situation.
In addition to this, I have been using the change tracking to keep up with what has been changed and to make sure that the various users are not making any major errors such as changing information in wrong rows, removing stuff by accident without realizing it, etc. But today when I loaded up the change tracker in a separate sheet, I noticed there were large gaps in the "Action Number" column. I compared this to data that had been entered on Friday and noticed that a lot of the information that was changed was not showing up as changed at all. It was just there (without comments, in most cases). I do not know if the two issues are related or not, but I thought it was worth mentioning.
And yes, I did make sure that I had it highlight all changes made by everyone throughout the last 30 days. It shows changes throughout the day, but the ones that show up are randomly dispersed throughout the day and for different users.
The disappearing comments happened to more than just one user as well. Out of the 4 users who made changes to the sheet Friday, 3 of them lost most of the comments made. 1 person's comments appear unaffected. That person also saved her information at some point in the middle of when other information was saved as she left after some and before others whose comments were lost.
TL;DR -
Shared Excel 2007 Document
Comments Disappearing for the First Time in Almost 2 Months
Change History/Tracking Not Showing Some Changes That it Should Be
Appears Not to be User Exclusive Problem
Any help is greatly appreciated.
Thank you for your time,
Chris (SodaAddict)
