Shared Files

[Ruth in Granville Ohio]

I searched through the message board on this subject but didn't find anything. There are 3 of us that share a file and update the information several times throughout the day, so we all have it open usually at the same time. What exactly happens if all three of us have the file open and the power goes out to the building and our computers? We will get the message that the file was saved and do we want to recover it. Do all three of us want to recover the file? This happened to us today. Since we are changing so much in this file, it will be difficult, if not impossible to tell if we lost anything. I just recently got a laptop and it has battery backup, so I wasn't affected by the outage. I saved the file after the power outage, even though my computer didn't lose power. When I saved, did that also save the other two users' work? - Ruth in Granville, OH

 

[andy3816]

Not sure if I know the answer to your question but I have been in similar situations where I wanted to know if another user had saved their updates in a shared file.

Ther is an option when you set up shared files to tarck changes, this creates a liston a seperate worksheet of who has changed what cell and gives the old and new values. It is also a very useful audit tool if mistakes get made

 

[Ruth in Granville Ohio]

I have that turned on. However, I also have conditional formatting turned on and any time the conditional formatting needs to be changed, you have to turn off the sharing. This in turn will remove the history, I think. My spreadsheet is almost 1000 rows and about 80 columns wide. Data is being added hourly. I'm concerned that when we have had power failures that the information is not being saved. The power went out without warning last week - no storms in the area. And when you have this much data that is being updated, it's pretty hard to remember everything you've done to the file since the last time it was saved.