Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

File error: data may have been lost

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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

In this modest contribution, I want to share with the IT community (especially system administrators, IT Support Engineers and IT Help Desks) about Windows crashes/hangs and how to deal with these particular problems.
Quickbooks hosting can do wonders to your enterprise but considering the points elaborated in the article which will help you to better analyze the outcomes. So scan your business, its needs and then move to the new world of limitless benefits.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

824 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