Solved

File error: data may have been lost

Posted on 2014-02-10
4
2,408 Views
Last Modified: 2014-02-10
We have three excel files that we save in Microsoft Excel 97-2003 format that we enter in mostly text into in that has worked fine for years but now we get an error message opening all three that say "File error: data may have been lost"

Any assistance offered with this would be greatly appreciated.
0
Comment
Question by:regsamp
  • 2
  • 2
4 Comments
 
LVL 23

Expert Comment

by:Eirman
ID: 39847279
When you select the file for opening in Excel 2003, you should see a dropdown arrow next to the Open button with a Repair Option.

The fact that all three have gone faulty, point to a hard disk / file corruption problem.

Do you have "System Restore" available for the drive that holds the files?
0
 

Author Comment

by:regsamp
ID: 39847309
I tried the Repair Option but it did not seem to work. Even the last backups were giving the error. What I did was just resave them with a different name and it seems to be working okay now. Monitoring now.
0
 
LVL 23

Accepted Solution

by:
Eirman earned 500 total points
ID: 39847318
Try rebuilding your projects as suggested here
http://www.mrexcel.com/forum/excel-questions/223851-rebuild-your-workbook.html
This should make them much less prone to corruption in the future.

Do you have the Analysis Tool Pak installed?
This sometimes causes this type of problem.
0
 

Author Comment

by:regsamp
ID: 39847333
Thank you. I will do that. I do not have the Pak installed.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Msbbox Notice (4 days) 27 59
Why do my Excel files become huge? 27 34
Formatting Excel Data as Table from Access 11 14
Embeded Images 13 13
Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
Outlook Free & Paid Tools
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

831 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