• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

When you open the Excel file, you receive the error: "file Error: data may be lost. "

Status
Not open for further replies.
D

doughnut

New Member
When you open the Excel file, you receive the error: "file Error: data may be lost. "After clicking OK, Excel closes. The file is written in Excel 2003. How to fix and open this file? Tried it on other computers with different versions of Excel - never opened. Changed the extension, etc. - did not help. I can mail the file myself.
 
A corrupt excel spreadsheet can be repaired by using Open and Repair technique. It is a built-in repair function that opens a corrupt excel file forcefully.
*OpenMS Excel >pressCtrl+O >locate corrupt excel spreadsheet and select it.
*Click on the arrow shown besideOpenbutton>selectOpen and Repair.
It will take just a few seconds to be completed and selected file will be opened, if possible.
 
Last edited by a moderator:
When you tried to access Excel file and this error occurs “File Error: Data May Have Been Lost”. It means Excel file is damaged or corrupt due to virus attack or human error. To fix this error try these methods:

1. Use the same version of Excel in which Excel worksheet created

2. If the 1st solution is not working then try “Open and Repair” inbuilt feature of MS Excel. Through this you can repair your damage excel file.

If both methods does not work then use any third party tool.
 
Last edited by a moderator:
It will take just a few seconds to be completed and selected file will be opened, if possible.Or you try to use [link removed by a moderator].
Click to expand...

To clarify to future readers, this link leads to a commercial tool for use on Microsoft Excel. It is NOT designed/built by Microsoft. As the link relates to the topic question, I'll remove the flag for potential spam.
 
Last edited by a moderator:
Sometimes users are troubled with different types of runtime errors by which they unable to access their Excel file. One of them Excel errors is “File Error: Data May Have Been Lost”.
In order to repair the damaged excel file you have to perform the following steps:
  1. Open the excel file.
  2. Now select the corrupted workbook that you want to open.
  3. Then click on Open and Repair by clicking the arrow next to the Open button.
  4. Now perform any one of the following:

  • Click on Repair in order to recover the data from excel.
  • To extract values and formulas from the workbook when an attempt to repair the workbook is not successful, click Extract Data.
https://support.microsoft.com/en-us...workbook-7abfc44d-e9bf-4896-8899-bd10ef4d61ab
 
Status
Not open for further replies.
Back
Top