[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

File error: data may have been lost

Posted on 2014-02-10
4
Medium Priority
?
2,782 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 24

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 24

Accepted Solution

by:
Eirman earned 2000 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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

Understanding the various editions available is vital when you decide to purchase Windows Server 2012. You need to have a basic understanding of the features and limitations in each edition in order to make a well-informed decision that best suits …
Recently, I read that Microsoft has analysed statistics for their security intelligence report. It revealed: still, the clear majority of windows users do their daily work as administrator. An administrative account is a burden, security-wise. My ar…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

590 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