Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2849
  • Last Modified:

File error: data may have been lost

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
regsamp
Asked:
regsamp
  • 2
  • 2
1 Solution
 
EirmanChief Operations ManagerCommented:
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
 
regsampAuthor Commented:
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
 
EirmanChief Operations ManagerCommented:
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
 
regsampAuthor Commented:
Thank you. I will do that. I do not have the Pak installed.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now