deanavey
asked on
excel losing data?
We have a client that requested a restore from a backup (shadow copy) of an excel file that appeared to have lost data. It's a shipping record sheet that is always kept up to date. So it should have data on today's date.
I restored to requested date and several other dates. Each file that is restored has lost exactly a months worth of data. So if I restore to 9/23, the last data entry was 8/23, or restore to 9/19 last data entry was 8/19. They were positive that at least on 9/9 data was 100% current. Restored to 9/9 and behold, data only shows 8/9.
Has anyone ever encountered this?
I restored to requested date and several other dates. Each file that is restored has lost exactly a months worth of data. So if I restore to 9/23, the last data entry was 8/23, or restore to 9/19 last data entry was 8/19. They were positive that at least on 9/9 data was 100% current. Restored to 9/9 and behold, data only shows 8/9.
Has anyone ever encountered this?
Are the date values manually entered, or are they formulas?
ASKER
It looks like its just manually entered.
Is it a Shared Workbook?
1) Is this workbook using the Share Workbook "feature", or has it ever used it in the past?
2) Is there any VBA code operating on this workbook?
2) Is there any VBA code operating on this workbook?
ASKER
It is on the file share yes so technically everyone has access. They claim only 1 user ever access that file though. And now that I've RDP into her PC, it looks like shes the only user that uses excel 2003 instead of 2010 like the others. I don't know if this makes a difference.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
1) Is this workbook using the Share Workbook "feature", or has it ever used it in the past?
yes I just checked and it is
2) Is there any VBA code operating on this workbook?
Absolutely none. All data is entered manually with the exception of simple math formulas like =SUM
yes I just checked and it is
2) Is there any VBA code operating on this workbook?
Absolutely none. All data is entered manually with the exception of simple math formulas like =SUM
ASKER
Just found this: under "who has this workbook open now"
User 1 - 9/27/11 (so today's date, which I do have the document open at the moment)
and user 2 - 4/15/2011 9:03am
user 2 doesn't have the workbook open and especially not from April!
User 1 - 9/27/11 (so today's date, which I do have the document open at the moment)
and user 2 - 4/15/2011 9:03am
user 2 doesn't have the workbook open and especially not from April!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ok, thanks for your help! We'll consider this a loss and lesson learned!