Fix the error 'File Error: data may have been lost' in Excel

MS Excel is a popular spreadsheet application from Microsoft that is widely used. Users use MS Excel to import, save and manipulate data in tables, rows and columns, calculations, statistical analysis .

However, in some cases when using Excel users often encounter many errors, in which the most serious error is data loss - File Error: data may have been lost.

In this case, users can still restore the data by using a backup file without errors.

Fix the error 'File Error: data may have been lost' in Excel Picture 1

Some causes of error "Error file: data may have been lost":

1. The first reason may be that the Excel file you opened is created on an earlier version of Excel that you are using the latest version of Excel.

1. Another reason may be due to an Excel file error.

To fix this error, you can open the Excel file on the same version of Excel that you created the file.

If the Excel file is still unable to open, it is likely that this Excel file has been corrupted. In this case you can refer to some of the ways below to fix the error:

- Try to open and fix Excel file errors by using the Open and Repair feature .

Fix the error 'File Error: data may have been lost' in Excel Picture 2

- Save the file in XML or HTML format and then convert the file back to normal format.

Fix the error 'File Error: data may have been lost' in Excel Picture 3

If your Excel file is using a chart associated with the corrupted file, you must use macros to extract the data.

If you still can't fix the error, you can remember the support of the 3rd application. Some software supports Excel data recovery as effectively as the Kernel.

Refer to some of the following articles:

1. Change the slash to a dot in Excel format

1. Instructions on how to automatically open a Workbook when you open Excel

1. How to change the default save file format in Word, Excel and Powerpoint 2016?

Good luck!