Solved

excel losing data?

Posted on 2011-09-27
10
257 Views
Last Modified: 2012-05-12
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?


0
Comment
Question by:deanavey
[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
  • 5
  • 3
  • 2
10 Comments
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 36710580
Are the date values manually entered, or are they formulas?
0
 

Author Comment

by:deanavey
ID: 36710590
It looks like its just manually entered.
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 36710607
Is it a Shared Workbook?
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 92

Expert Comment

by:Patrick Matthews
ID: 36710622
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?
0
 

Author Comment

by:deanavey
ID: 36710653
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.
0
 
LVL 92

Assisted Solution

by:Patrick Matthews
Patrick Matthews earned 125 total points
ID: 36710679
>>It is on the file share yes so technically everyone has access.

Not quite what I meant.  Excel has a Share Workbook feature that enables >1 people to edit a file at the same time, but no one I know recommends it, because it leaves workbooks dangerously unstable.

>>They claim only 1 user ever access that file though.

Let's hope so :)

>>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.

It shouldn't...
0
 

Author Comment

by:deanavey
ID: 36710705
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
0
 

Author Comment

by:deanavey
ID: 36710727
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!

0
 
LVL 92

Accepted Solution

by:
Patrick Matthews earned 125 total points
ID: 36710737
My standard screed about "Share Workbook":

---------
The consensus opinion of Experts here is that using 'share workbook' should be assiduously avoided.  This is a poorly implemented feature in Excel that leaves workbooks highly vulnerable to corruption.  If true multi-user capability truly is needed, then the best practice is to use a database platform such as Access, SQL Server, MySQL, etc.

Just about the only use for shared workbooks endorsed by the Experts here is to enable 'track changes', and even then, the workbook should still not be used by multiple users at the same time.

It is only a small exagerration to say that there are only two kinds of shared workbooks: those that have become corrupted, and those that soon will be :)
---------

In all seriousness, using that feature is asking for trouble, and I think your users have found it.

Patrick
0
 

Author Closing Comment

by:deanavey
ID: 36710788
Ok, thanks for your help! We'll consider this a loss and lesson learned!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
When speed and performance are vital to revenue, companies must have complete confidence in their cloud environment.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

749 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