?
Solved

excel losing data?

Posted on 2011-09-27
10
Medium Priority
?
260 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
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
LVL 93

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 93

Assisted Solution

by:Patrick Matthews
Patrick Matthews earned 500 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 93

Accepted Solution

by:
Patrick Matthews earned 500 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

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

This article describes a serious pitfall that can happen when deleting shapes using VBA.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

777 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