4 Ways to extract data from corrupt Excel file

Summary: Excel files can become corrupt due to numerous reasons. This blog will discuss the reasons behind the corrupted Excel files. Sometimes the file becomes inaccessible. This post includes four ways to extract data from a corrupt Excel file. It also mentioned Stellar Repair for Excel to repair severely corrupted files. The tool helps you recover data from damaged Excel files with complete integrity.

Imagine the frustration of an employee if an Excel workbook he took hours to complete became corrupted for some reason threatening to erase all the data saved in it. Not just that, a corrupted Excel workbook can wreak havoc for the organization too since it poses a risk of permanently deleting critical business information like work records or employee trackers.

Unless a backup of all important Excel files exists, recovering data lost due to damage/corruption to them is next to impossible. However, we’ve conducted some research and found some pretty neat hacks to help you extract data from corrupt excel files without much hassle.

Primary reasons triggering Excel file corruption

As we always point out, to solve a problem for good, getting to its root is imperative. Here are the main reasons that cause Excel file corruption. Knowing these reasons can help you keep Excel corruption at bay for a considerably long time.

• Abrupt system shutdown when you’re editing an Excel sheet
• Bugs / Defects in your Excel application or installation
• Hardware failures like bad sectors on the hard drive where Excel sheets are saved
• Virus Infection / Malware Attack
• Excessive data storage within a single Excel file
• Faulty Excel Macros and CSE Formulas

Depending upon the extent of damage, there can be several ways to perform corrupt Excel file repair.

How to repair corrupt Excel files?

There are a couple of manual methods that can help you repair corrupt Excel files .

1. If the damaged Excel sheet can be opened, immediately save its copy; thereafter:
   • Open it with a later version of Excel and save it as a new workbook.
   • If this doesn’t work, open it in Excel’s latest version and save the workbook in HTML or HTM format.
   • Once this is done, reopen the HTML file and save again in XLS format.
   • Lastly, open the file and try saving it in SLK format (symbolic link)

Note: It is important to note that saving an Excel workbook in HTML format causes loss of features like custom views, scenarios, unused styles or number formats, natural language formulas, data consolidation settings, custom function categories, etc. In SYLK format only the active worksheet is saved so if using this method, you’ll need to repeat these steps for each worksheet.

2. Use Excel’s inbuilt Repair function as follows:
   • Launch Microsoft Excel and go to Office button -> Open
   • In the Open dialog box, select the damaged Excel file
   • On the bottom-right corner of the Open dialog box, you will find a drop-down next to Open Click on it and select Open and Repair
   • This will launch the inbuilt Repair module of Excel and you’ll see a dialog box asking you to select an option from Repair or Extract Data
   • Click on Repair to initiate the repair process.
   • If this doesn’t work, repeat steps 1-4, and when Excel asks you to select an option, select Extract Data from corrupt excel file. Thereafter, follow the instruction Excel shows and you should be able to retrieve your data, but you may end up losing some formulas.
3. If you cannot open the Excel, download Spreadsheet viewer from the Microsoft website and open the file using this program. Thereafter copy all data into a new Excel.

Note: This method will cause much of your formatting, formulas, and more to be lost.

4. You can download Open Office from its official website OpenOffice.org and try opening the Excel in it. The two programs are very similar so all data should automatically align in the correct place and with the correct formatting.

Note: With this method, VBA code cannot be recovered due to incompatibility between OpenOffice.org and Excel.

Full-proof method for corrupt Excel file repair

If you find the above methods confusing, or you wish to perform Excel file repair without having to face any data and formula loss, or you cannot achieve the desired results with any of these methods, stop wasting any more time with methods that will only frustrate you more. Instead, download the sure-shot solution for dealing with severe Excel corruption –Stellar Repair for Excel  and relax!

Stellar Repair for Excel is the best choice for repairing corrupt or damaged Excel (.XLS/.XLSX) files and restoring everything to a new blank Excel file. This competent software can skillfully repair single as well as multiple XLS/XLSX files while preserving worksheet properties and cell formatting. If you have this product by your side, you don’t need to worry about Excel corruption errors ever again.

To Conclude

Instead of giving up on corrupted Excel sheets, try repairing them with the simple tricks we’ve described. And if they don’t work, keep calm and turn to Stellar Repair for Excel.

‘Open and Repair’ Doesn’t Work in MS Excel

Summary: In this Blog, we will go through Microsoft office most important product i.e Microsoft excel, let’s get into all possible Manual and an alternate method to deal with MS Excel open and Repair doesn’t work issue, read on to know more.

Whether you are a student or an entrepreneur, the features of Microsoft Excel do not delude anyone. Setting goals, creating budgets, analyzing data, calculating salaries, is there anything that Excel can’t do? All of us have used it and trusted it to calculate and provide a solution to our most difficult problems. However, like every other software application, this otherwise reliable application can sometimes fall prey to unexpected errors which can even threaten to make our critical data inaccessible.

A good idea to avoid loss of data when a Microsoft Excel file becomes corrupt is to take some proactive measures, such as saving a backup copy of your files and creating an automatic recovery file at periodic intervals. If you are faced with a corrupted Excel file, you know you can still use the ‘Open and Repair’ function provided by Microsoft to fix and open corrupt Excel file. However, what should a user do when ‘Open and Repair’ is not working? This is a query shared by millions of Excel users worldwide. Sometimes, the ‘Open and Repair’ functionality of Excel stops working due to unknown reasons. In such cases, if users face Excel file corruption, they get stuck with no idea how to fix the Excel file.

Manual method “Reference”

In this guide, we’re providing you with the solutions to this very problem. If Excel ‘Open and Repair’ is not working, read on to find out the procedures that you can perform to open corrupted files.

‘Open and Repair’ doesn’t work: Try an alternative solution i.e. Stellar Repair for Excel to recover everything from corrupt Excel files.

How to Fix Excel file that Won’t Open

If your workbook is opening in Excel, there are two options to recover its data. It would be best if you try to perform one, and if you are unsuccessful, move on to the next.

Revert the workbook to the version that was saved before the corruption

• Launch Excel and click File -> Open

• Select the file that is corrupted and open it
• Click ‘Yes’ to save the copy of the workbook that was saved before corruption

Important Note: If you use this method, you will lose all changes made to the file after it was corrupted.

Save the workbook in the SYLK file format

• Launch Excel and click File -> Save As.
• In the Save as Type field, select SYLK (Symbolic Link) from the drop-down menu, and click Save.

• To save only the active sheet in the workbook, click OK. The system will display a message that the sheet has features that are not compatible with the SYLK file format.
• Click Yes.
• In Excel click File -> Open.
• Select the file that you saved in SYLK file format and open it.
• In Excel click File -> Save As.
• In the Save as Type field, select Excel Workbook from the drop-down menu.
• In the File Name field, type a new name for your workbook and click Save.

The SYLK file format will filter out the corrupted elements from your workbook, thereby restoring your data.

Important Note: Using this method you only be able to salvage the active sheet in the workbook.

How to Open/Fix an Excel file that cannot be opened

In this case too, there are two options to recover the data. Try to perform one, and if you are unsuccessful, move on to the next.

Set the calculation option to Manual

• Launch Excel and click File -> New.

• From the Available Templates window, select Blank workbook.

• Click File -> Options.
• Under Formulas, in the Calculation options section, click Manual.

• Click OK.
• In Excel click File -> Open.
• Select the corrupted file and open it.

The system opens the corrupted file. Since the workbook won’t be calculated, it might open.

Link the workbook to external references

• Launch Excel and click File -> Open.
• Copy the name of the corrupted file and click Cancel.
• In Excel click File -> New.
• From the Available Templates window, select Blank workbook.
• In the new workbook, on cell A1, type the following:

=File Name!A1

In the above command, the filename is the name of the corrupted file.

• On the Update Values dialog box, select the corrupted file and click OK.
• On the Select Sheet dialog box, select the sheet and click OK.
• Select cell A1. Select the same range of rows and columns as occupied by the data in the corrupted sheet, including cell A1.
• Under the Home tab, in the Clipboard section, click Paste.
• While the range of rows and columns are still selected, click Copy.
• Click the Paste
• Under Paste Values, click Values.

Note: This method lets you recover only the data but not the values and formulas from the workbook.

Alternative Solution

In addition to the above-mentioned techniques, you can also use macros to extract data from a corrupted workbook. However, macros are generally risky, and executing them needs prior technical knowledge.

Thus, if the above methods do not yield the desired results, a quick and easy way for reconstructing Excel files is to use Excel Recovery Software . Stellar Repair for MS SQL software is the best choice for rebuilding damaged Excel files and restoring everything to a new Excel file. The product lets you recover table, chart, chart-sheet, cell comment, image, formula, sort and filter data from damaged workbooks and also allows you to fix multiple files at one go.

Wrapping it up

Though one of the above-mentioned techniques should recover Excel file if ‘_Open and Repair’ utility doesn’t work_, in case you’ve reached nowhere even after using them, contact Microsoft support for more help.

Summary: Recovering your unsaved Excel file on Windows 10 with some of our tested methods can truly save you a lot of time, money, and effort. Here’s how to do it!

Microsoft provides a wide range of applications to its users that cater to different purposes. Out of all the MS Office applications, Excel is considered the most used native application by several companies and individuals to store and process crucial data. Excel can also be called a go-to data analysis tool that offers great reliability, ease of use, and multiple features. But unfortunately, it’s not immune to human errors and system errors.

What if you accidentally close the Excel file without saving your work or Excel crashes suddenly? Or worse! Your system crashes without any warning and when you reboot your system, you can’t find the unsaved Excel file.

There could be different situations where you may lose access to your unsaved Excel workbook. There is no need to be anxious, though! We’ve covered some easy-to-follow DIY methods in this post to help you recover unsaved Excel files quickly.

4 Ways to Recover Unsaved Excel File

Irrespective of the circumstances, you can recover unsaved Excel files on Windows 10 using the following methods.

Method 1: Use the Search Option

If you remember the name of the Excel file, try to find it using the Search option. Following these steps:

• Go to Windows Search Box and type the name of the file.
• If you find the file there, click Open or Open file location.

• If you click Open file location, it will take you to the exact location of the file, and you’ll be able to regain access to lost/unsaved Excel file easily.

Method 2: Use AutoRecover Feature

Microsoft Excel comes with a built-in AutoRecover feature that saves copies of all open Excel files at a user-definable fixed interval. You can recover the file if you forget to save it and accidentally close it or it closes automatically due to an unexpected system breakdown or power failure. You can follow the given steps to recover unsaved Excel files with the AutoRecover feature:

• Open a new Excel file and go to File > Options.
• Then go to Save > Save workbooks.
• Next, ensure that the ‘Save AutoRecover information every’ and ‘Keep the last autosaved version if I close without saving’ option is already selected.

• Now, copy the file path given against the AutoRecover file location.
• Open the File Explorer, paste the Menu Bar file path there, and hit Enter.
• The unsaved file will appear with the .xlb extension.
• Double-click the file and choose Excel from apps to open the .xlb file.

• Finally, save the file to the desired location.

Method 3: Use the ‘Recover Unsaved Workbooks’ Option

Another way that you can choose is the ‘Recover Unsaved Workbooks’ option. To regain access to your Excel file, follow the given steps:

• Open an Excel sheet and then go to File > Open.
• Now, scroll down and click Recover Unsaved Workbooks.

• The list of unsaved files will show in the Document Recovery pane.
• Locate the file you lost and double-click on it to open.
• Finally, right-click on the version of the file you want to restore and click Save As.

And, save the file to the desired location

Method 4: Restore File with Previous Versions Utility

This feature will help you recover unsaved Excel files when you’ve saved the workbook earlier, but you end up losing access to the file due to an Excel or system crash. It’d help you save the previously saved version of your Excel file. To do so, follow the given steps:

• Open an Excel file and navigate to File > Info > Manage Versions.

• It will show the previously saved versions. You can choose the one you want to restore and click Save/Save As to store the file with a different name.

Hopefully, this blog has helped you learn how to recover unsaved Excel files. You can try any of the above methods.

FAQ

1. How can I repair a corrupted workbook?

Whenever Excel detects a corrupted workbook while opening, it automatically starts running the File Recovery mode and repairing the file. If the File Recovery mode doesn’t start automatically, you can manually repair the corrupted workbook .

How to Fix Excel Run Time Error 1004

Summary: Run-time errors are windows-specific issues that occur while the program is running. This blog will teach you how to fix Excel run-time error 1004. In addition, you’ll learn about an Excel repair tool that can help fix the error 1004 if it occurs due to corruption in Excel files.

VBA (Microsoft Visual Basic for Application) is an internal programming language in Microsoft Excel. Sometimes, when users try to run VBA or generate a Macro in Excel, the Run-time error 1004 may occur. This error may occur due to the presence of more legend entries in the chart, file conflict, incorrect Macro name, and corrupt Excel files. In this blog, we have discussed the reasons and shared some solutions to resolve run-time error 1004.

Why This Error Occurs?

The run time error 1004 usually occurs when you run a VBA macro with the Legend Entries method to modify the legend entries in the MS Excel chart. It happens when the chart contains more legend entries than the available space, macro name conflicts, corrupt Excel files, or data-types mismatch in the VBA code.

Ways to Fix Excel Run-Time Error 1004?

Try the below workarounds to fix Excel run-time error 1004:

Create a Macro to Reduce Chart Legend Font Size

Sometimes, Excel throws the run-time error when you try to run VBA macro to change the legend entries in a Microsoft Excel chart. This error usually occurs when Microsoft Excel truncates the legend entries because of the more legend entries and less space availability. To fix this, try to create a macro that shrinks/minimize the font size of the Excel chart legend text before the VBA macro, and then restore the font size of the chart legend. Here is the macro code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

VBCopy
Sub ResizeLegendEntries()

With Worksheets("Sheet1").ChartObjects(1).Activate
      ' Store the current font size
      fntSZ = ActiveChart.Legend.Font.Size

'Temporarily change the font size.
      ActiveChart.Legend.Font.Size = 2

'Place your LegendEntries macro code here to make
         'the changes that you want to the chart legend.

' Restore the font size.
      ActiveChart.Legend.Font.Size = fntSZ
   End With

End Sub
Note: Make sure you have an Excel chart to run the code on the worksheet.

Uninstall Microsoft Work

You may encounter a run-time error 1004 in Excel version 2009 or older versions due to conflicts between Microsoft works and Microsoft Excel. This error usually occurs if your system has both Microsoft Office and Microsoft Works. Uninstalling one of them will fix the issue. Try the below steps to uninstall Microsoft Work:

• First, open the Task Manager using the shortcut CTRL + ALT + DEL altogether
• The Task Manager window is displayed.

• Click the Process tab, right-click on each program you want to close, and then click End Task.
• Stop all the running programs.
• Open the Run window and type appwiz.cpl to open the Programs and Feature window.

• Search for Microsoft Works and click Uninstall.

Try Deleting GWXL97.Xla File

The Add-ins files with .xla extension in MS-EXCEL is used to provide additional functionality to Excel spreadsheets. Sometimes, deleting the GWXL97.XLA file fixes the run-time error. Here are the steps to delete this file:

• Make sure you have an Admins rights, open the Windows Explorer
• Follow the Path C:\Programs Files\MSOffice\Office\XLSTART.
• Find and right-click on the GWXL97.XLA file
• Click Delete.

Change Trust Center Settings

Sometimes, run-time errors might arise because of incorrect security settings. The Trust Center settings help you find the Privacy and security settings for Microsoft Excel. Follow the below steps to change the Trust center settings:

• Open Microsoft Excel.
• Go to File > Options.
• The Excel options window is displayed.
• Choose Trust Center, and click Trust Center Settings.
• Tap on the Macro Settings tab, and select Trust access to the VBA project object model.

• Click OK.

Run Open and Repair Tool

The Runtime error also arises when MS Excel detects a corrupted worksheet. It automatically begins the File recovery mode and starts repairing it. However, if the Recovery mode fails to start, use the Open and Repair tool with the below steps:

• Click File > Open.
• Click the location and folder with a corrupted workbook.
• In the Open dialog box, choose the corrupted workbook.
• Click the arrow next to the Open tab, and go to the Open and Repair tab.
• Click Repair.

You can also opt for Stellar Repair for Excel if the Microsoft Excel’s built-in tool cannot fix the error.

Use Stellar Repair for Excel

Stellar Repair for Excel is a professional software for repairing damage. xls, .xlsx, .xltm, .xltx, and .xlsm files and recovering all its objects. Here are the steps to fix the error using this tool:

• First, download, install, and run Stellar Repair for Excel.
• Click the Browse tab on the interface window to choose the corrupted Excel file you need to repair.
• Click Scan. You will see the scan progress in the scanning window.
• Click OK.
• The tool can let you preview all the recoverable Excel file components including tables, pivot tables, charts, formulas, etc.
• Click Save to save the repaired file.
• A Save File dialog box will appear with the below two options:
• Default location
• New location
• Choose a suitable option.
• Click the Save option to repair the Excel file that you have chosen.
• Once the repair is complete, it will display a message “File repaired successfully.”
• Click OK.

Conclusion

Now you know the Excel run-time error 1004, its cause, and solutions. Follow the workarounds discussed in the blog to rectify the error quickly. However, Stellar Repair for Excel makes your task of removing run-time errors easy. It’s a powerful software to fix all the issues with Excel files. Also, it helps in extracting data from the damaged file and saves it to a new Excel workbook.

[Fixed] Excel Cannot Open the File Because the File Format or File Extension Is Not Valid

When opening an older version of an Excel file in a newer version, you may encounter the “Excel cannot open the file because the extension is not valid” error. This happens if you have accidentally renamed the file with a different file format or an incorrect file extension. Also, you may get the ‘Excel cannot open the file’ error if the file has become unreadable or corrupted.

This is how the complete Excel error message looks like:

“Excel cannot open the file filename.xlsx because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.”

Check out this video for a quick demonstration of how to fix “Excel Cannot Open the File Because the File Format or File Extension Is Not Valid”

How to Fix the ‘Excel Cannot Open the File Because the File Format or Extension Is Not Valid’ Error?

Try any of these workarounds to fix the error and regain access to your Excel file data:

Workaround 1 – Change the Default File Format

By default, an Excel file is saved in .xlsx or .xls file format. Trying to open the file with a different or incorrect extension may cause the ‘Excel cannot open the file because the extension is not valid’ error. To fix the error, try changing the Excel default file format by following these steps:

Note: Take a backup of the Excel file that you cannot open and try the steps on the backup copy.

• In Excel 2010 and newer versions, click on the File menu.

Note: For Excel 2007 and earlier versions, click on the Office button.

• On the left panel, click on Options. 
• In ‘Excel Options’ window, under Save workbooks section, click on the Save files in this file format: drop-down. Select a file format (i.e., the one supported by your Excel version).

• Click OK.

Check if you can open your Excel file. If not, try the next workaround.

Workaround 2 – Edit the Excel File Permissions

You may receive the ‘Excel file format or file extension is not valid’ error if you lack sufficient permissions to open the file. Usually this happens when you try to open an Excel file received from some other user. Follow these steps to change the file permissions and see if it fixes the problem:

• Right-click on the file that won’t open and click Properties.
• In the file properties dialog box, click the Security tab and then hit the Edit button.

• When the file’s permissions dialog box appears, click on the Add button.

• Click on the Advanced button from the ‘Select Users or Groups’ window.

• Select Find Now. A list of all users and groups will get displayed in a search results box. Choose Everyone group from the list and hit OK.

• You can see the ‘Everyone’ group in the ‘Enter the object names to select’ textbox. Click OK once again to return to the file’s permission dialog box.

• Click Everyone from the Group or user names: box and check all the checkboxes under Allow.

• Click on Apply and then OK.

Now try to open the Excel file. If you’re still getting the Excel file cannot open error, use the following workaround.

Workaround 3 – Recover Unsaved Workbook

If the ‘Excel file extension not valid error’ occurs when attempting to open an unsaved workbook, do the following to recover the unsaved workbook:

• In Excel, click File. 
• From the Info screen, under Manage Versions, click Recover Unsaved Workbooks.

Excel will list any unsaved files. Try opening the file and save it. If this doesn’t work, skip to the next workaround.

Workaround 4 – Repair the Workbook

If none of the above workarounds has worked for you, chances are that the Excel file has become corrupted. Try to repair the file using the Excel inbuilt ‘Open and Repair’ utility by following these steps:

• In your Excel application, click on File > Open.
• In the ‘Open’ dialog box that pops-up, select the Excel file you want to repair and click the arrow next to the Open button.

• From the dropdown list, select Open and Repair.

• Excel will ask you to attempt to repair the file or extract data from it. Click Repair to retrieve maximum data. If the Repair option fails, click on Extract Data to recover the data without formulas and values.

If the ‘Open and Repair’ utility doesn’t help fix the corrupted file and/or recover the data, use an Excel repair tool  such as Stellar Repair for Excel to regain access to your file and its data.  

Stellar Repair for Excel software can help repair severely corrupted XLS and XLSX files. Also, it helps recover all the file components, including tables, pivot tables, cell comments, charts, chart sheets, images, formulas, etc., without impacting the original structure of the Excel file. 

To learn how the software works, read this: How to repair corrupt Excel file using Stellar Repair for Excel?

Conclusion

You may encounter the error ‘Excel cannot open the file because the extension is not valid’ when opening a workbook with a different file format or an incorrect file extension. Also, the error may occur if the Excel file has turned corrupt. This article has covered some of the most effective workarounds to resolve the error. But if nothing works, you can try to repair the Excel file and retrieve its data using the Stellar Repair for Excel software.

How to Resolve ‘Excel found unreadable content in filename.xlsx’ Error in MS Excel?

When opening an Excel spreadsheet in MS Office 2010/2007, you may get the following error message:

“Excel found unreadable content in ‘[filename].xlsx’. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes.”

On clicking ‘Yes’, you may face any of these scenarios:

Note: If you choose to click ‘No’, then open your MS Excel application and click file > Open. When the Open dialog box opens, browse and select the file showing the ‘Excel found unreadable content’ error and then choose ‘Open and Repair’ option. If this didn’t help, try using a third-party Excel repair tool to save time troubleshooting the issue and restoring the file with all its data intact.

Scenario 1: The following message may pop-up.

“Excel was able to open the file by repairing or removing the unreadable content. Excel recovered your formulas and cell values, but

some data may have been lost

. Click to view log file listing repairs errorxxx.xml.”

The message clearly states that your Excel file might open, but images may be lost and other such inconsistencies can crop up.

Scenario 2: The error is followed by another error message, like “The file is corrupt and cannot be opened“.

Watch our short video for a quick overview of the solutions to fix “Excel found unreadable content in filename.xlsx”

What Causes ‘Excel Unreadable Content’ Error?

You may encounter the ‘Excel file unreadable content’ error due to corruption of complete Excel file or corruption in certain areas (like Pivot Table, Formulas, Styles, or other objects) in the file. According to Microsoft, you may find it difficult to determine the root cause behind Excel file corruption. Corruption could occur in different scenarios, like power surge, a network glitch, copying and pasting corrupted data from another file, etc.

Also Read: How to recover data from corrupt or damaged Excel file 2010 & 2007?

Workarounds to Resolve the ‘Excel found unreadable content in filename.xls’ Error

There is no permanent solution to fix the ‘Excel found unreadable content’ error. But, following are some workarounds you can try to resolve the error.

Note: Before you try any of these workarounds, run Excel with administrator privileges and try opening the Excel file that is throwing the ‘unreadable content’ error. If this doesn’t fix the error, proceed with the workarounds below.

Workaround 1 – Try Opening the File in Excel 2003

Sometimes a problem in the current Excel version might prevent a file from opening. To resolve this error, try opening the problematic file in Excel 2003. If the file opens, save the data in a web page file format (.html) and then try opening the .html file in MS Excel 2010/2007. The detailed step-wise instructions are as follows:

• Open the .xls file in Excel 2003.
• When the file opens, click on File > Save.
• In the ‘Save As’ dialog box, choose Web Page (.html) as the ‘Save as type’ and then click ‘Save.’ Doing so will save everything from your .xls file, opened with 2003, in .html file format.
• Open the .html file in Excel 2010/2007. And then, save the file with .xlsx extension with a new name to avoid overwriting the original file.

Now, open the Excel 2010/2007 file and check if the error is fixed. If not, use the next workaround.

Workaround 2 – Make the Excel File ‘Read-only’

Try to open your ‘.xlsx’ file by making it ‘read-only’. Follow these steps:

• In Excel, click ‘File’ from the main menu.
• Select ‘Save’ for a new document or ‘Save As’ for a previously saved document in the screen that appears.

• From the ‘Save As’ dialog box, click Tools > General Options.

• Click on the ‘Read-only recommended’ checkbox to make the document read-only and then click ‘OK’.

Now open a new ‘.xlsx’ file and copy everything from the corrupt Excel file to this new file. Finally, save this file and try to open it again.

Workaround 3 – Move Excel File to a New Folder

Some users have reported that they could open their Excel file, following the ‘Excel unreadable content’ error, by simply moving the file to a different folder and saving it under a new name. You can also move the affected file to a new folder and try opening it. If this didn’t help resolve the error, follow the next workaround.

Workaround 4 – Install Visual Basic Component

At times, it is seen that installing the ‘Visual Basic’ component of MS Office 2010 resolves the ‘Excel found unreadable content 2010’ error. To do so, follow these steps:

• Navigate to Control Panel > Programs and select Microsoft Office 2010.
• Click ‘Change’ and then select ‘Add or Remove Programs’.
• Next, click the ‘plus’ sign provided next to Office Shared Features.
• Click ‘Visual Basic for Applications’. After that, right-click and choose ‘Run from My Computer’ and hit the ‘Continue’ button.
• Reboot your system when this process finishes.

Now check if the issue has been resolved or not.

What Next?

If none of the workarounds mentioned above works for you, use a professional Excel repair software, such as Stellar Repair for Excel. The software repairs corrupt MS Excel sheets without modifying their original content and formatting. In addition, it can repair single or multiple Excel (XLS/XLSX) files in a few simple steps.

Steps to Repair Corrupt Excel File using Stellar Repair for Excel Software

• Install and run Stellar Repair for Excel software.

• From the software main interface window, click ‘Browse’ to select the corrupt file. If you are not aware of the corrupt Excel file location, click on the ‘Search’ button.

• Click on the ‘Repair’ button to scan and repair the selected file.

• A preview window will open with recoverable Excel file data. Once satisfied with the preview result, click on the ‘Save File’ button on the ‘File’ menu to start the repair process.

• Select the destination to save the file.

• Click ‘OK’ when the ‘Repaired file saved successfully’ message appears.

 The repaired Excel file will get saved at the selected location.

How to Fix “Errors were detected while saving Excel” Error?

When trying to save the Excel file, you might face unexpected errors. The “Errors were detected while saving Excel” is one such error. It can also occur when using VBA in Excel. The complete error message appears as:

**“Errors were detected while saving [file name]. Microsoft Excel may be able to save the file by removing or repairing some features. To make the repairs in a new file, click Continue. To cancel saving the file, click Cancel.”
**

The error can occur if the features (Pivot tables, charts, macros) used in the Excel file get corrupted . However, there could be several other reasons behind the occurrence of the error. Let’s discuss them.

What Causes the “Errors were detected while saving Excel” Error?

There are various reasons why you encounter this error. Here are some of them:

• Incompatible pivot table in the Excel file
• Large or uncompressed images in the Excel file
• File-sharing properties are not allowing file saving
• Excel file is corrupted
• Large-sized Excel file
• File version incompatibility
• VBA code is corrupted

Ways to Fix the “Errors were detected while saving Excel” Error

You’re not able to save the Excel file if there is no storage space on your hard drive. So, first check if your hard drive has sufficient storage space to save the file. If this is not the case, then it might happen that your antivirus program is interrupting the saving process. To check this, temporarily disable your antivirus program and then try to save the file. If still your Excel is throwing the “Errors were detected while saving Excel” error, then follow the below given methods to fix the error:

Method 1: Open the Excel in Safe Mode and Disable the Add-ins

When you open Excel in safe mode, it opens without the third-party add-ins. This helps in finding out if any add-ins are causing the error.

 Here’s how to open the Excel in safe mode:

• Open the Run window by pressing Windows key + R.

• Type excel /safe in the Run window.

  ?

• Next, click on OK.

• It will open Excel in safe mode.

• Now, try to open and save the affected file.

If you are able to save the file without any issue, then this means that the error has occurred due to third-party add-ins or settings. You can try disabling the add-ins to fix the issue. To do this, follow these steps:

• First, open Excel.
• Then, go to the File tab and click Options.

• In Excel Options, click on the Add-ins

• Under the Manage section, select Excel Add-ins and then click on the Go

• In the Add-ins dialog box, unselect the add-ins under the Add-ins available option and click OK.

  

Note: Disabling add-ins does not remove them from the system. To remove them permanently, you need to uninstall them.

Method 2: Check the Excel File Name

Some users have observed this error when saving the Excel file with an invalid name. You can check the file name and ensure that it should not contain more than 218 characters. If the name exceeds the required limit, then try shortening the file name or move the file to a folder with a short path name.

Method 3: Copy the Data from the Affected File to a New File

If you are not able to save the Excel document, then try copying the data from the affected file to a new Excel file. Then, save the new file with a different name. This helps in resolving the issue.

Method 4: Check and Provide File Permissions

You may experience the “Errors were detected while saving Excel” issue when you do not have desired permissions to modify the folder in which your Excel file is located. To modify the folder, you should have read, write, and create permissions. You can check and provide the desired permissions using the below steps:

• Navigate to the Windows Program Files and then find the desired folder (where the Excel file is saved).
• Right-click on the folder and then choose Properties.
• Select the Security tab and then click
• Click on Change Permissions in the Advanced Settings
• Click Administrators and then click Edit.
• Now set the Apply to drop-down button to This Folder, Subfolder, and Files.
• Click on the Full Control field and then click Apply > OK.

Method 5: Check Pivot Tables in Excel Sheet

You can review Pivot tables to see if they are causing the “Errors were detected while saving Excel” error. To do so, follow the below steps:

• Click Power Pivot > Manage.

  

• Check the tabs in the Power Pivot

• Check if all the formulas used in the table are correct. Sometimes, even a small typo can create an issue in Excel.

Method 6: Repair Your Excel File

The “Errors were detected while saving Excel” issue can also occur if the Excel file is corrupted. In such a case, you can take the help of the built-in utility in Excel – Open and Repair to repair your Excel file. Here’s how to use the tool:

• In Excel, click the File tab and then click Open.
• Click Browse to select the desired file.
• The Open dialog box is displayed. Click on the corrupted file.
• Click on the arrow next to the Open button and then click Open and Repair.
• Click on the Repair

• After repair, a message will appear (as shown in the below figure).

  

• Click Close.

 However, sometimes, the Open and Repair utility fails to fix the file if it is severely corrupted or large-sized. In such a case, you can take the help of a third-party Excel repair software, such as Stellar Repair for Excel. The tool performs a comprehensive scan of the corrupted Excel file to fix the issues and recover all the items from the file without changing the original formatting. It can recover pivot tables, charts, images, engineering formulas, etc. The tool is compatible with Windows 11/10/8.1/8/7. You can download the free trial version of the tool to evaluate its functionality.

Closure

Many Excel users reported facing the situation when they are saving the Excel file. You can check the file’s compatibility to fix the “Errors were detected while saving Excel” issue. If you are getting this error in a Macro-enabled file then you can try deleting the VBA project from a document to resolve the issue. However, deleting the entire VBA code cannot be a better solution as it can lead a data loss in the Project you are working on. In the above article, you have learned the reasons behind the issue and discovered how to fix the error. Follow the methods and if none of them works then try using Stellar Repair for Excel. It is an advanced tool that can quickly repair corruption in Excel worksheets at any level. It lets you restore the corrupted components from the corrupted file without removing the existing data.

Also read: