Solved

excel losing data?

Posted on 2011-09-27
10
258 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
Industry Leaders: 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!

 
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

If you ever consider purchasing any Daossoft Software Products, DON'T expect any meaningful support - This article should convince you why!
Learn how the use of a bunch of disparate tools requiring a lot of manual attention led to a series of unfortunate backup events for one company.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

734 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