Solved

File error: data may have been lost

Posted on 2014-02-10
4
2,485 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
[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
  • 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

RoboForm Secure Password Management System

RoboForm Everywhere - Superb Browser Support
Windows / Apple / IOS / Android / Linux / Chrome OS
Use different complex passwords everywhere
Best Secure Password Management by far
Synchronize all of your devices instantly
Safe, Secure & Highly Recommended!

Question has a verified solution.

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

Configuring Remote Assistance for use with SCCM
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

752 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