ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Shared Workbook User had unsaved information disappear (https://www.excelbanter.com/excel-worksheet-functions/253495-shared-workbook-user-had-unsaved-information-disappear.html)

Aeryn635

Shared Workbook User had unsaved information disappear
 
We share a workbook and my co-worker came to me today and insists she typed
information in multiple cells which is now missing. We do track the history
and I saw no record of the information. She insists she saved her
changes....but if she did not, is it possible it disappeared? We had the
update changes setting to Automatically every 5 minutes but not save "Just
see other users' changes". Could this have removed her data?

She was so frustrated I could not even look on her computer to see things
from her point of view. She insists the info just vanished...

ryguy7272

Shared Workbook User had unsaved information disappear
 
Shared workbooks do some really bizarre things. I've used them in the past,
but due to the inconsistencies you described as well as completely corrupted
worlbooks, i would never use this feature again. If you find yourself
exceeding the limits of Excel, it's probably time to move on to <S Access (or
SQL Server with a .NET front-end.

Good luck.



--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Aeryn635" wrote:

We share a workbook and my co-worker came to me today and insists she typed
information in multiple cells which is now missing. We do track the history
and I saw no record of the information. She insists she saved her
changes....but if she did not, is it possible it disappeared? We had the
update changes setting to Automatically every 5 minutes but not save "Just
see other users' changes". Could this have removed her data?

She was so frustrated I could not even look on her computer to see things
from her point of view. She insists the info just vanished...



All times are GMT +1. The time now is 01:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com