File Format and Extension of [filename] don’t Match in Excel File

Summary: The “File format and extension of [filename] don’t match. The file could be corrupted or unsafe” error message indicates that the Excel file you’re trying to open is unsupported, unsafe, or corrupted. Read this article to learn more about this error and how to fix this error. It also mentions an advanced Excel recovery tool to repair the corrupted Excel file and retrieve all its data in a few clicks.

You can encounter the “File format and extension of [filename] don’t match. The file could be corrupted or unsafe” error when the Excel application detects any issue with the file. This happens when you try to open an old version file format in a newer version or if the file is received from an unsafe destination. This can prevent you from opening the Excel file.

As indicated from the error message, this error occurs due to the following reasons:

• The file has incorrect file extension.
• The file is corrupted.
• The file you are trying to open is protected.

Now, let’s see how to resolve this Excel error.

Methods to Fix the “File format and extension of [filename] don’t match” Error

Try the following methods to troubleshoot the “File format and extension don’t match” error in Excel.

Method 1: Rename the Excel File

You can face the “File format and extension don’t match” issue if the file has incorrect extension. It can occur if the file extension has been altered or you’ve mistakenly saved the file with incorrect extension. To fix this, you can try renaming the Excel file with the correct file extension.  

Method 2: Check the Default Excel File Format

Different versions of Microsoft Excel use different default file formats. For example, .xls is the default file format of older versions (2003 and lower) of Excel, whereas .xlsx format is used by the newer versions (2007 and later). Opening the Excel file with an incompatible extension can cause the “File format and extension don’t match” issue. You can check the Excel version you are using and ensure it’s compatible with the Excel file you are trying to open.

Method 3: Change the Protected View Settings

You may receive the “File format and extension of excel don’t match” error if the Excel file is protected. You can check and try disabling the Protected View settings .  

Caution: Changing the Protected View settings can put your system at risk. If the Excel file is being downloaded from the internet, it may contain viruses that can infect your system. So be careful before disabling the Protected View settings.

Steps to Change Protected View Settings in Excel:

• In the Excel’s File menu, click on Options.
• Select Trust Center > Trust Center Settings.

• Under Trust Center, select Protected View and disable the below three options:
• Enable Protected View for files originating from the internet.
• Enable Protected View for files located in potentially unsafe locations.
• Enable Protected View for Outlook attachments.

• Click OK. Then, try to open the Excel file.

Method 4: Check and Provide the Excel File Permissions

Sometimes, you can get the error if you don’t have sufficient permissions to open the Excel file. This usually happens when you try to open the Excel file received from other sources. You can check and provide the desired permissions to fix the error. Here are the steps:

• Locate the affected Excel file, right-click on it, and select Properties.

• In the Properties window, click the Securities option and select Edit.

• In the Security window, under ‘Group or users name’, select the user names. Check the file permissions and make sure Full Control is enabled. If not, then click on the Add option.

• Click on the Advanced option in the Users, Computers, Service Accounts, or Groups window**.**

• Click the Find Now option. A list of all users and groups appears in the search field.

• Select “Everyone” from the list and then click OK.

• In the object names field, you will see ‘Everyone’. Click on OK.

• In the Permissions window, select “Everyone” and enable all options (Full Control, Modify, Read & Execute, Read, and Write) under Permissions for Everyone.

• Click Apply and then OK.

Method 4: Repair your Excel File

As the error message indicates, corruption is one of the causes of the “File format and extension of [filename] don’t match” error. If your file is corrupted, you can repair it using Microsoft’s built-in Open and Repair tool. Here are the steps to run the Open and Repair tool to repair corrupted Excel file:

• In Excel, click on File.
• Click Open and then click on Browse to select the corrupted Excel file.
• In the Open dialog box, click the Excel workbook (in which you are facing the error).
• Click the arrow next to the Open button and select Open and Repair.
• Then, click Repair to recover as much data as possible.
• The Excel prompts a message after the repair process is complete. Click Close.

The Open and Repair utility may fail to give the intended results. In such a case, you can repair the corrupted/damaged Excel file using a specialized Excel repair tool . Stellar Repair for Excel is one such tool that can repair severely corrupted Excel files. With the help of this tool, you can quickly recover all the objects from the Excel file. The tool has a simple user interface that even a non-technical can use to repair the Excel files. The tool can also repair multiple Excel files at once. You can check the tool’s functionality by downloading its demo version.

Closure

You can encounter the “File format and extension of [filename] don’t match” error due to different reasons. To resolve the issue, you can check the file extension, permissions, protected settings, etc. If you suspect the error has occurred due to corruption in the Excel file, you can try repairing the Excel file using the Open and Repair tool. If nothing works for you, then try Stellar Repair for Excel . It can repair highly damaged Excel files and recover all the data while preserving the file properties and cell formatting. The tool can help you fix all the common corruption-related errors quickly.

Get Rid of corrupt Excel File

Summary: What to do when an Excel file is corrupted? This is a common question that is often asked by Microsoft Excel users. If you too are seeking an answer to this question, read the blog to learn about a few manual workarounds and a specialized Excel file repair tool to resolve the Excel file corruption issue.

An Excel file gets corrupted due to various reasons such as a virus/malware attack, sudden system shutdown when the Excel file is still open, power failure while working with an Excel spreadsheet, etc.

When Microsoft Excel detects corruption in a workbook, it attempts to repair the workbook by starting ‘File Recovery mode’.

Tip! If the file recovery mode doesn’t start, you may use the manual repair process or an Excel repair tool, such as Stellar Repair for Excel to repair a corrupted Excel file. The software can help you quickly retrieve contents from a damaged, corrupt, or inaccessible Excel file and restore the file to its original state.

There even exist a few manual tips that can be used to recover data from damaged MS Office Excel files.

Workarounds to Use When an Excel File is Corrupted

Note: Before carrying out any of the repair and recovery workarounds, it is advised that you must save a backup copy of the damaged file. This is to prevent your files from turning completely inaccessible in case the methods fail to give desired results.

Workaround 1: Use the Open and Repair Method

If MS Excel cannot repair a corrupted workbook automatically, you can try to do it manually. To do so, perform the following:

• Open the corrupt file, like you normally open any file, by clicking File > Open.
• Browse and locate the folder containing the corrupted document.
• When the Open dialog box is displayed:
• Select the Excel document.
• Click on the arrow present to the right side of the Open button and select Open and Repair option.

Figure 1 – Open and Repair Feature

If this doesn’t help repair the broken Excel file or you encounter  Open and Repair does not work issue, proceed with the next workaround.

Tip! Try an alternative solution, i.e. Stellar Repair for Excel software to repair and recover corrupt Excel files (.xlsx or .xls) when the ‘Open and Repair’ method won’t work.  

Workaround 2: Restore an Excel File with a Shadow Copy

If you’re a Windows 7 or Vista user, you can try restoring the corrupted spreadsheet by using a shadow copy (or a previous version). [Shadow copy](https://en.wikipedia.org/wiki/Shadow_Copy#:~:text=Shadow%20Copy%20(also%20known%20as,the%20Volume%20Shadow%20Copy%20service .) is basically a snapshot (backup copy) of computer files or volumes. The snapshot may contain an older version of your Excel file that has become damaged now. To find out, do the following:

• Launch File Explorer, and right-click the folder in which the file is saved.
• Choose Properties.
• Look for and click the Previous Versions tab. This will display a list of entries under Folder versions or File versions, going back a few days or weeks.
• Double-click one with a date when the file was accessible and could be read. Then, try to open its older version. If it opens, save the older version with a new name and execute the procedure with new file/folder entries.

Figure 2 – Volume Shadow Copy

You would have to repeat the process until you reach the point where the file became damaged. With this, you will get a baseline version of the file, but data may still have been lost.

Workaround 3: Test your Assumptions

If you receive a message saying “Excel file corrupted and cannot be opened”, you would probably believe it. However, there could be other reasons besides corruption that may cause Excel to throw this error message.

Your Office suite, which Excel is a part of, maybe having some primary issues in it causing problems while opening one Excel document. So, try opening another Excel file to check if the problem exists with all the files or just one.

If other Excel documents work correctly, it means that only the particular document is corrupt. On the contrary, if the issue is with your Office suite, repairing the current Office installation may help fix the issue. For this, perform these steps:

• Go to Control Panel and click Uninstall the Program.
• Choose Office.
• Click Change, and hit the Repair button.

You can reinstall the entire Office package. Once reinstalled, try to open the file to check if the issue has been fixed and the Excel file repaired.

Figure 3 – MS Office Repair

Workaround 4: Use Excel File Repair Tool

If the above manual solutions fail, use Excel repair software to successfully repair your damaged Excel workbook and recover all its data. Essentially, the software rebuilds damaged Excel workbook data at a granular level to recover every single object & all the original properties of the workbook.

Suggested Read: How to repair corrupt Excel files using Stellar Repair for Excel?

Why Use Stellar Repair for Excel Software?

• Repairs severely corrupted XLSX and XLS files.
• Can handle corrupt Excel files of any size.
• Demo version allows previewing recoverable Excel file items for free.
• Supports Microsoft Excel 2019 and all lower versions.
• Compatible with Windows 10 and lower versions.
• Tested and recommended by Microsoft Excel MVPs.

Final Word

When an Excel file is corrupted, it won’t open at all or you won’t be able to access all the file data. Such a situation can lead to unnecessary halts, impacting work productivity.

There are manual workarounds that may help fix the corrupt Excel file and recover its data, such as the ones covered in this blog. However, these solutions might not work in severe corruption cases and may require technical assistance. Also, they may result in some data loss.

To overcome the limitations of manual workarounds, it is recommended to go for a professional Excel file repair tool such as Stellar Repair for Excel . It helps repair corrupt Excel (XLS or XLSX) files and restores all worksheet data, such as the table, chart, chart sheet, cell comment, sort and filter, image, formula, etc. in a few simple clicks. Moreover, the software provides a free preview of the recoverable data with its demo version. You can check the preview to evaluate how the software works.

How Can I Recover Corrupted Excel File 2016?

Error Messages Indicating Corruption in Excel File

• When an Excel 2016 file turns corrupt, you’ll receive an error message that reads: “The file is corrupt and cannot be opened .”

• But sometimes, you encounter the “Excel cannot open this file” error message due to corruption in the file.

Why does Excel File turn Corrupt?

Following are some common reasons that can turn an Excel file corrupt:

• Large size of the Excel file
• The file is virus infected
• Hard drive on which Excel file is stored has developed bad sectors
• Abrupt system shutdown while working on a worksheet

Workarounds to Recover Data from Corrupt Excel

The workarounds to recover corrupted Excel file 2016 data will vary depending on whether you can open the file or not.

How to Recover Corrupted Excel File 2016 Data When You Can Open the File?

If the corrupt Excel file is open, try any of the following workarounds to retrieve the data:

Workaround 1 – Use the Recover Unsaved Workbooks Option

If your Excel file gets corrupt while you are working on it and you haven’t saved the changes, you can try retrieving the file’s data by following these steps:

• Open your Excel 2016 application and click on the Open Other Workbooks option.

• Click the Recover Unsaved Workbooks button at the bottom of the ‘Recent Workbooks’ section.

• A window with list of unsaved Excel files will open. Click the corrupt file you want to open.

This will reopen your last saved version of the Excel workbook. If this method doesn’t work, proceed with the next workaround.

Workaround 2 – Revert to Last Saved Version of your Excel File

If your Excel file gets corrupt in the middle of making any changes, you can recover the file’s data if the changes haven’t been saved. For this, you need to revert to the last saved version of your Excel file. Doing so will discard any changes that may have caused the file to turn corrupt. Here’s how to do it:

• In your Excel 2016 file, click File from the main menu.
• Click Open. From the list of workbooks under Recent workbooks, double-click the corrupt workbook that is already open in Excel.
• Click Yes when prompted to reopen the workbook.

Excel will revert the corrupt file to its last saved version. If it fails, skip to the next workaround.

Workaround 3 – Save the Corrupted Excel File in Symbolic Link (SYLK) Format

Saving an Excel file in SYLK format might help you filter out corrupted elements from the file. Here are the steps to do so:

• From your Excel File menu, choose Save As.
• In ‘Save As’ window that pops-up, from the Save as type dropdown list, choose the SYLK (Symbolic Link) option, and then click Save.

Note: Only the active sheet will be saved in workbook on choosing the SYLK format.

• Click OK when prompted that “The selected file type does not support workbooks that contain multiple sheets”. This will only save the active sheet.

• Click Yes when the warning message appears - “Some features in your workbook might be lost if you save it as SYLK (Symbolic Link)”.

• Click File > Open.
• Browse the corrupt workbook saved with SYLK format (.slk) and open it.
• After opening the file, select File > Save As.
• In ‘Save as type’ dialog box, select Excel workbook.
• Rename the workbook and hit the Save button.

After performing these steps, a copy of your original workbook will be saved at the specified location.

How to Recover Corrupted Excel File 2016 Data When You Cannot Open the File?

If you can’t access the Excel file, apply one of these workarounds to salvage the file’s data.

Workaround 1 – Open and Repair the Excel File

Excel automatically initiates ‘File Recovery’ mode on opening a corrupt file. After starting the auto-recovery mode, it attempts to reopen and repair the corrupt Excel file at the same time. If the auto-recovery mode does not start automatically, you can try to fix corrupted Excel file 2016 manually by using ‘Open and Repair’. Follow these steps:

• Open a blank file, click the File tab and select Open.
• Browse the location where the corrupt 2016 Excel file is stored.
• When an ‘Open’ dialog box appears, select the file you want to repair.
• Once the file is selected, click the arrow next to the Open button, and then click the Open and Repair button.
• Do any of these actions:
• Click Repair to fix corrupted file and recover data from it.
• Click Extract Data if you cannot repair the file or only need to extract values and formulas.

If performing these actions doesn’t help you retrieve the data, proceed with the next workaround.

Workaround 2 – Disable the Protected View Settings

Follow these steps to disable the protected view settings in an Excel file:

• Open a blank 2016 workbook.

• Click the File tab and then select Options.

• When an Excel Options window opens, click Trust Center > Trust Center Settings.

• In the window that pops-up, choose Protected View from the left side navigation. Under ‘Protected View’, uncheck all the checkboxes, and then hit OK.

Now, try opening your corrupt Excel 2016 file. If it won’t open, try the next workaround.

Workaround 3 – Link to the Corrupt Excel File using External References

If you only need to extract Excel file data without formulas or calculated values, use external references to link to your corrupt Excel 2016 file. Here’s how you can do it:

• From your Excel file, click File > Open.
• From the window that opens, click Computer and then click Browse and copy the name of your corrupt Excel 2016 file. Click the Cancel button.

• Go back to your Excel file, click File > New > Blank workbook.

• In the new Excel workbook, type “=CorruptExcelFile Name!A1” in cell A1 to reference cell A1 of the corrupted file. Replace the ‘CorruptExcelFile Name’ with the name of the corrupt file that you have copied above. Hit ENTER.
• If ‘Update Values’ dialog box appears, select the corrupt 2016 Excel file, and then click OK.
• If ‘Select Sheet’ dialog box pops-up, select a corrupt sheet, and press the OK button.
• Select and drag cell A1 till the columns required to store the data of your corrupted Excel file.
• Next, copy row A and drag it down to the rows needed to save the file’s data.
• Select and copy the file’s data.
• From the Edit menu, choose the Paste Special option and then select Values. Click OK to paste values and remove the reference links to the corrupt file.

Check the new Excel file for recoverable data. If this didn’t work, consider using an Excel file repair tool to retrieve data.

Alternative Solution to Recover Excel File Data

Applying the above workarounds may take considerable time to recover corrupted Excel file 2016. Also, they may fail to extract data from a severely corrupted file. Using Stellar Repair for Excel software can help you overcome these limitations. The software helps repair severely corrupted XLS/XLSX file and retrieve all the file data in a few simple steps.

Key benefits of using Stellar Repair for Excel are as follows:

• Recovers tables, pivot tables, images, charts, chartsheets, hidden sheets, etc.
• Maintains original spreadsheet properties and cell formatting
• Batch repair multiple Excel XLS/XLSX files in a single go
• Supports MS Excel 2019, 2016, 2013, and previous versions

Check out this video to know how the Excel file repair tool from Stellar® works:

Conclusion

Errors such as ‘the file is corrupt and cannot be opened’, ‘Excel cannot open this file’, etc. indicate corruption in an Excel file. Large-sized workbook, virus infection, bad sectors on hard disk drive, etc. are some reasons that may result in Excel file corruption. The workarounds discussed in this article can help you recover corrupted Excel file 2016 data. However, manual methods can be time-consuming and might fail to extract data from severely corrupted workbook. A better alternative is to use Stellar Repair for Excel software that is purpose-built to repair and recover data from damaged or corrupted Excel file.

[Solved] Excel Spreadsheet Disappears after Opening

Several Excel users have reported about experiencing ‘Excel spreadsheet disappears after opening’ issue. The problem occurs when attempting to open an Excel file by double-clicking on the file icon or name. The Excel file opens blank grey screen.

Figure 1 - Excel Blank Screen

User Instances of ‘Excel Open But Can’t See Spreadsheet’ Issue

Instance 1: The user said that “Excel 2016 opens to a blank screen and everything is greyed out. Ribbons at the top of Excel are also not present”.

Instance 2: The user reported that “Attempting to open a spreadsheet, either by double-clicking the file or by opening Excel, it opens but only a blank Excel window is visible. When trying to save that particular file, Excel behaves as though there is no file open at all and all the file saving options, such as save, save as, print, etc. are greyed out.”

Causes Behind ‘Excel Open But Can’t See Spreadsheet’ Issue & the Solutions Thereof

Following are some of the possible reasons behind the ‘Excel open but can’t see spreadsheet’ issue, along with their solutions:

Cause 1: Excel File is Hidden

You may have saved the Excel sheet as a hidden document.

Solution: Unhide Excel File

Verify if your Excel worksheet is hidden by following these steps:

• In Excel, click the View tab, and then click Unhide.

Note: If the ‘Hide’ tab under the View menu is greyed out, the sheet you’re trying to open is not hidden. In that case, proceed to the next workaround.

Figure 2 - Unhide Excel File

• A dialog box will pop-up showing the worksheet name that can be unhidden. For instance, below is an image of Unhide box that lists ‘Daily_Reports’ spreadsheet under Unhide workbook.

Figure 3 – Select and Unhide Excel Workbook

• Click OK to unhide your Excel sheet.

If this fails to work, there’s a possibility that the spreadsheet window pane may have slided to one side of the visible desktop. To bring back the displayed area, click the ‘Arrange All’ option under the View tab. If the issue persists, try the next solution.

Cause 2: Ignore Dynamic Data Exchange (DDE) Option is Enabled

Another reason behind the ‘Excel opens to a blank screen’ issue could be that the “Ignore other applications that use Dynamic Data Exchange (DDE)” checkbox is checked in Excel options.

Usually, when you double-click an Excel file, a DDE message is sent to Excel instructing it to open that particular file. But, if you have the ‘Ignore DDE’ option selected, the DDE message sent to Excel to open a workbook is ignored. As a result, the Excel workbook opens a blank screen.

Solution: Uncheck the Ignore DDE Option

Make sure that the ‘Ignore DDE’ option is unchecked by performing these steps:

Note: Skip these steps for Excel 2019 and Excel Office 365.

• In your Excel window, click File > Options.

Figure 4 - Select Excel Options

• From the left-side of the ‘Options’ window, choose Advanced.

Figure 5 - Excel Options Window

• In ‘Advanced’ window, locate the General section, and then uncheck the “Ignore other applications that use Dynamic Data Exchange (DDE)” checkbox.

Figure 6 - Uncheck Ignore Other Applications that use DDE

• Click OK to apply the changes.

If these steps don’t work, proceed to the next workaround.

Cause 3: Issue within Office Program

Sometimes, problem within your Microsoft Office program might cause Excel to behave oddly and may result in an Excel spreadsheet disappeared issue.

Solution: Repair Office Program

Try repairing your Office program by executing the steps listed below, based on your Windows OS:

For Windows 10:

• Type Settings in the Windows search box.
• Click Settings.
• In ‘Windows Settings’ screen, select Apps.

Figure 7 - Windows Settings Screen

• In ‘Apps & features’ screen, scroll down to your Microsoft Office program and tap on it, and then click the Modify

Figure 8 - Modify MS Office Program

• In ‘How would you like to repair your Office programs’ dialog box, select the Online Repairradio button, and then click the Repair

Figure 9 - Repair MS Office Program

For Windows 8:

• Open Control Panel and click the Uninstall a program option under Programs.
• Select Microsoft Office 365 and then click Change.
• In the window that opens, select Online Repair and then hit the Repair

You may be asked to restart your system after completion of the repair process.

For Windows 7:

• In ‘Control Panel’ window, double-click Programs and Features.
• Under Uninstall or change a program section, select the Office program, and then select Change.
• In the dialog box that appears, choose Online Repair and then choose Repair.

If repairing your Office installation fails to resolve the issue, continue to solution 4.

Cause 4: Problematic Excel and COM Add-ins

Sometimes, Excel and COM add-ins may cause Excel file open a blank grey screen problem.

Solution: Disable the Add-ins

Disabling the Excel and COM add-ins one at a time may help resolve the problem. The steps are as follows:

• Click the File menu in your Excel file and select
• From ‘Excel Options’ left-side panel, click Add-Ins, and then choose COM Add-ins from the ‘Manage’ drop-down. Click the Go

Figure 10 - Select COM Add-ins

• Uncheck one of the add-ins checkbox from the COM Add-ins window, then select OK.

Figure 11 - Uncheck and Disable COM Add-ins

• Restart your Excel program.

If the issue persists, repeat the above steps (1 till 4), except that you need to choose a different add-in in step 3.

If you’re still experiencing the same problem after unchecking all the COM add-ins, repeat all the above steps, except choose ‘Excel Add-ins’ in step 2.

If Excel can load the file, then the add-in that you disabled last leads to the problem. If turning off add-ins does not work, try the next solution.

Cause 5: Problem with Excel File Associations

The Excel file opening a blank screen problem may occur if the file associations are not performing correctly.

Solution: Reset Excel File Associations

Try resetting the file associations in Excel to their default settings. For this, follow the below steps based on your OS.

For Windows 10 and Windows 8.1:

• Select the file that is opening incorrectly and copy it to the desktop.
• Right-click the file and click Properties.
• In the File’s ‘Properties’ window, check your file type next to Type of Filefrom the General tab. For instance, (.docx), (.csv), or (.pdf).
• Next, check to which app your file is associated with from the Opens withoption

If the file type is different than .xlsx, open the file in a different application by following these steps:

• Click the Change button next to the ‘Opens with’ option.
• Click More apps.
• From the list of applications, select the desired app and then check the Always use this app Click OK.

For Windows 8:

• Open Control Panel, click Default Programs, and then select Set your default programs.
• Choose Excel and then tap the Choose default for this program
• In ‘Set Program Associations’ window, choose Select All and then click Save.

For Windows 7:

• In Control Panel, choose Default Programs.
• Click the Associate a file type or protocol with a specific program
• Choose Microsoft Excel Worksheet and click on change program.
• Choose Microsoft Excel under Recommended Programs.
• If you’re unable to find Excel, browse the Excel installation folder.
• Select exe and then choose Excel.

What Next? Use Stellar Repair for Excel to Recover Your File

If the above solutions don’t help recover your Excel file, use an Excel file repair tool, such as Stellar Repair for Excel to recover it. The software can restore the Excel spreadsheet and its components, including tables, pivot tables, charts, formulas, etc. while preserving the spreadsheet properties and formatting.

Check out the video to recover Excel file by using Stellar Repair for Excel software.

Conclusion

This article described the possible causes behind the ‘Excel open but can’t see spreadsheet’ issue, along with their solutions. The manual solutions to resolve the issue require time and efforts. But, if you need to access your Excel file without any delay, use Stellar Repair for Excel software to recover your .xlsx/.xls file in just a few clicks.

Excel AutoRecover not working, what is next?

Consider a Scenario

A professional with Windows 10 computer had MS Office 2016 installed on it. For an official purpose, he worked on an Excel workbook and saved it as an XLSX file. After working for hours on it, which was saved with a file name, a power outage occurred in his building for quite some time. After the power was back, he reopened Excel to find a list of recovered files in ‘Document Recovery’ section on the screen’s left side. However, the file that he had worked on recently was the ‘Original version,’ i.e. the last version saved by him and not the auto-saved Excel file. This meant the Excel document did not have any new data that was entered since the last time he saved it. Consequently, he lost hours of work. According to him, this happened despite the fact that the ‘AutoRecover’ feature was enabled. (Still, this needs to be checked and ensured.)

The ‘AutoRecover’ feature might not work in any of these cases:

• AutoRecover Feature is disabled - With this feature disabled, the Excel files are not auto-saved if the document is closed without saving, or the document closes unexpectedly due to an untoward incidence. To check, see if ‘Save AutoRecover information every * minutes’ and ‘Keep the last auto-saved version if I close without saving’ checkboxes are checked or unchecked. If either one is unchecked or both are unchecked, it signifies that the AutoRecover feature is disabled. Else, the AutoRecover is enabled.
• Corruption in the Excel XLSX file – If ‘AutoRecover’ is enabled, most probably the cause is ‘damaged Excel XLSX file.’

Before discussing solutions to resolve the ‘Excel AutoRecover not working’ issue, let’s have an overview of the ‘AutoRecover’ and ‘AutoSave’ features.

A Brief Overview of Excel AutoRecover and AutoSave Feature

AutoRecover is an inbuilt feature in MS Excel 2019, 2016, 2013, 2010, 2003, and 2007 that allows saving all of the ‘open Excel files’ at a fixed-interval in a user-specified location or AutoRecover file location. Besides, AutoSave is an add-in that exists in Excel 2002 and earlier versions to save all open Excel files in case of a crash, power outage, or accidental closure of Excel files without saving. Users can recover these files if Excel closes suddenly, for instance, at the time of power outage or failure. The auto-recovered Excel files are saved at a default location.

Methods to Fix ‘Excel AutoRecover Not Working’ Issue

Manual Methods

Method 1 - Enable the ‘AutoRecover’ Feature if Disabled

Make sure that you have the ‘AutoRecover’ feature enabled in your Excel application. If not, follow these steps to enable it:

• Open Excel with MS Excel 2016/2019
• Click on File and then on Options tab
• In ‘Excel Options’, click on Save tab
• Check ‘Save AutoRecover information every * minutes’ and ‘Keep the last auto saved version if I close without saving’ box
• Set the time in ‘Save AutoRecover information every * minutes’
• Click on the OK button

Note: With this method, it is not possible to recover data from the current Excel file. From next time onwards, the AutoRecover feature starts working following which Excel shall start auto-saving Excel files as per the time set in ‘Save AutoRecover information every * minute’.

Method 2 - Repair Corrupt Excel File

If corruption in Excel XLSX file has resulted in ‘Excel AutoRecover not working’ issue, you will need to repair Excel file . Use ‘Open and Repair’ inbuilt utility to fix and repair the damaged (corrupt) Excel file and extract its data. To use the inbuilt utility, execute the following steps:

• Go to location “C:\Users\AppData\Local\Microsoft\Office\UnsavedFiles” to find Excel TMP files and save it as XLSX file

Note: In Windows 8, the location is the same as mentioned above that is for Windows 10. In Windows 7, the location is “C:\Users\name\AppData\Roaming\Microsoft\Excel\”

• Open a blank Excel sheet; click File >> Open
• Go to the location and folder containing the damaged Excel file
• In the Open dialog box, choose the damaged Excel file and click the arrow next to the Open button, and then click Open and Repair
• In the window that appears, click Repair to recover as much data as possible

Now, open the Excel (XLSX) file to check if the Excel file is repaired and its data is recovered.

Use a Professional Excel File Repair Tool

Using a third-party Excel file repair tool can help you repair damaged Excel XLSX file and recover all the data. Stellar Repair for Excel  is one tool you can rely on to repair severely corrupt Excel files (XLSX or XLS).

Here are a few other reasons why you should choose Stellar Repair for Excel software:

• Repairs Excel file while keeping the worksheet properties and cell formatting same as before.
• Recovers all of the Excel file components like tables, forms, reports, charts, chart sheets, cell comments, formulas, images, etc.
• Can batch repair multiple Excel files simultaneously
• Supports Excel 2019 and earlier versions

Conclusion

To help resolve the problem of ‘AutoRecover not working’, different methods have been discussed, depending on the cause of the problem. These solutions can be implemented to check the possibility of getting back maximum data added in last saved version of the Excel file. However, to fix corruption in the excel file, using a specialized tool such as Stellar Repair for Excel software recommended by MS Excel Experts and MVPs can help. The software can repair severely damaged Excel file easily and efficiently.

How to Fix a Corrupted .xls File? The Everything Guide

Undoubtedly, Excel is so powerful that it can help you to process, analysis, and store data, in masses.

That’s the reason it has been there for years and helping this world in data.

But…

With all those powers comes some nasty problems which no Excel users like to face. Can you guess what I’m talking about?

Think about a Corrupted Excel File. Nightmare? Isn’t it?

And do you remember that last time when you have opened a workbook and you got a message that this workbook is might corrupt?

The TRUTH is, this is something which you cannot avoid, but, you can prepare yourself in the best way and deal with it like a PRO.

So today, in this post, I’d like to share with you to everything you need to know about a corrupt Excel file (.xls), why it happens, how to fix it like a PRO, and much more.

…let’s get started.

Note: In this post, we’ll be covering the .xls version (which is the extension for the file which is created in Excel 2007 or the earlier versions) and if you want to know about the new version, here’s the quick fix for that.

Why My Excel File Got Corrupted?

There can be one or multiple reasons for an Excel file to get corrupted. Below I have detailed about some of the major of them.

1. Large Excel File

You can store data in a workbook the way you want but sometimes using excessive thing can make an Excel file bigger in size.

And that kind of data files can crash at any point in time. Here are a few things which make the Excel files heavy, like

• Conditional Formatting.
• Colors formatting.
• Using merged cells in place of text alignment.
• Volatile functions: Formulae that iterate every time you open or change a cell value; OFFSET, NOW.
• Using a complete column or row as a reference than the data set range.
• Using complex formulas; VLOOKUP in place of Index/Match, Nested If in place of MAXIFS, MINIFS.
• Calculations or reference across workbooks.

Related: How to Fix Formatting Issues in Excel

2. Abrupt System Shutdown

Shutting down the system without following the procedure can corrupt your data file.

This shut down can be due to a power failure or any other unexpected technical challenges.

So it is always important to follow the procedures and shut down your system properly to avoid data losses.

3. Infected Excel File (Virus Attack)

This is the most common and obvious reason for Excel file corruption.

Although we always keep our system safe using various Antiviruses, still there is always a probability of virus attacks and loss of important files.

It is always advised to use a safe and strong antivirus compatible with your system requirements.

What are the Signs to Know When an Excel File is Corrupted?

In this section, we will discuss what are the signs which you can get when an Excel file is corrupted, let’s dig into it.

1. The File is Corrupt and Cannot Be Opened

This is one of the most common messages you can see when your workbook is corrupted.

But there is also a chance that it is just because of the version compatibility where you have a .xls file but you are using the latest version of Excel check out this detailed post by Priyanka

2. We Found a Problem with some Content in this File…

There’s another error message which you can get while opening a file:

We Found a Problem with some content in Do you want us to recover as much as we can? If you trust the source of this workbook, click yes.

There are a lot of applications out there (I think almost every) which exports the data as a .xls format. Those files have a greater chance of having this kind of error.

3. “Filename.xls” cannot be accessed

There can also be a situation where you get the error:

“Filename.xls” cannot be accessed. The file may be corrupted, located on a server that is not responding.

Well, this message is a bit misleading.

You won’t be able to decide that your file is actually corrupted or just not on the location.

My Excel File Got Corrupted, now What Should I Do?

There are many ways to recover the data from the corrupt excel files. But before you start, it is always advised to create a copy of the corrupted file.

You can save a lot of time with Stellar Repair for Excel, which make data recovery just with few clicks.

But before you go for a data recovery software, let’s try out some manual steps which can help.

When a workbook get corrupted the first thing comes to the mind is to recover data from it…

…and you what there’s a simple option there in the Excel which you can use to do this. Below are the steps you need to follow:

• First of all, open the Excel and click on the office icon.

• After that, go to the “Open” and select the file which is corrupted.

• Now, click on the open drop-down and select “Open and Repair”.

• At this point, you have two options:

1. Repair File
2. Extract Data

Let’s get into both of these options one by one…

1. Repair File

This option helps you to repair the file and the moment you click on it it takes a few seconds afterward and shows you the result with a message box and also provide you a log file.

And once it is done with repairing, you’ll get your file opened and you can save that file as a new copy.

Yes, that’s it.

2. Extract Data

If somehow you aren’t able to get your file repaired, you can also extract data from that file using “Extract Data” option.

Even in this option, you can get data in two ways.

1. As Values
2. With Formulas

In the first option, Excel simply extracts data as value ignoring all the formulas driving those value (which is the best way if you just need to have that data back ).

But in the second option, Excel tries to recover the formulas as much as possible.

Check out this smart technique by Jyoti which you can use it you aren’t able to recover data from the file.

Preventions to Not to have any Excel File Go Corrupt in Future

Future is fragile, what I’m trying to say is the more you work in Excel and process data there could be a chance that your workbook goes corrupt.

If there’s no security then what an EXCEL POWER user should do?

Well, there are few things which you can do or take care of while working with Excel so that you won’t have to worry about corruption of Excel workbooks.

Let’s see what you can do…

1. Change Recalculation Option

Now here’s the thing when you work with a hell lot of data, there a common thing that you gotta using formulas. Right?

But, the thing these formulas are something which makes your Excel file slows down sometimes make them go corrupt.

There’s one small tweak you can do in your workbook is change the calculation method.

Now with the manual calculation, you just need to whenever you open your file it won’t recalculate all the formulas.

And when you update your data you can simply click on the “Calculate Now” and it will calculate all the formulas again.

Quick Tip: Beware of Volatile Functions and use them with caution as recalculates them every time you change something in the worksheet.

2. Use VBA Codes Instead of Formulas

Now, this is what I do when I need to use complex formulas in a workbook.

Here’s how you can do this: Let’s say you have a formula in the cell A1, like below, which calculates the age.

=“You age is “& DATEDIF(Date-of-Birth,TODAY(),”y”) &” Year(s), “& DATEDIF(Date-of-Birth,TODAY(),”ym”)& “ Month(s) & “& DATEDIF(Date-of-Birth,TODAY(),”md”)& “ Day(s).”

Now, instead of simply entering it into the cell A1 which I would write a macro code which inserts this formula into the cell A1 and then convert it into the a value.

Here’s the code:

Sub CalculateAge()
Range(“B1”).Value = _
“=””Your age is “”” & _
“&DATEDIF(A1,TODAY(),””y””)” & _
“&”” Year(s), “”” & _
“&DATEDIF(A1,TODAY(),””ym””)” & _
“&”” Month(s), and “”” & _
“&DATEDIF(A1,TODAY(),””md””)” & _
“&”” Days(s).”””
Range(“B1”) = Range(“B1”).Value
End Sub

Note: To write these code you need to have basic understading of VBA (make sure check out this guide for this).

3. Use a File Recovery Application

Recently we asked a quick question to our readers on ExcelChamps that if they have ever faced a situation where they got a corruption message in Excel.

You’ll be astonied to hear that 50% percent of the people said “YES” they faced this thing in the past.

Now, this is alarming, if you are heading a team or you have a bunch of people in your company who use Excel…

…there’s a high probability that half of them gonna face this issue. So the best way to deal with this to have an App FIX your Excel file for you.

With STELLAR REPAIR FOR EXCEL, you just need a few clicks, yes that’s right. Let me show you with the below steps:

• First of all, download the app and install it (it’s simple).

• After that, open the app and click on the “Browse” and simply select the file which is corrupted.

• In the end, click on the REPAIR to let the Excel repair software fix your file (it takes a few seconds).

Once you complete repairing your file, you’ll get a message in your on the status bar and after that, you can open your file.

Final Thoughts

If you are a POWER Excel user then there’s a must for you to have known how to deal with a situation where you got a corrupt Excel file.

But I must recommend you to TRY OUT Stellar Repair for Excel so that’s you don’t have to worry about your Excel files anymore.

I’m sure you found this post helpful, and please don’t forget to share this tip with your colleagues, I’m sure they’ll appreciate it.

[Fixed] Excel Found a Problem with One or more Formula

Summary: The error ‘Excel found a problem with one or more formula references in this worksheet’ may appear while saving the Excel workbook. It occurs when Excel found a problem with the formula used in the sheet. However, it may also occur when the Excel workbook gets damaged or corrupt. In this guide, we’ve explained the reasons that may lead to this Excel error and methods to resolve the error, by using various Excel options and a third-party Excel file repair software.

If you are experiencing the ‘Excel found a problem with one or more formula references in this worksheet’ error message in the Excel workbook, it indicates that the Excel file is corrupt or partially damaged. However, it may also occur due to incorrect reference to a wrong cell or object linking, which is not working. The complete error message says,

‘Excel found a problem with one or more formula references in this worksheet. Check that the cell references, range names, defined names, and links to other workbooks in your formulas are all correct.’

In any case, resolving the error is critical as it doesn’t let you save the file and may result in loss of information from the Excel workbook.

Reasons for Excel Formula References Error

A few reasons that may lead to such error are as follows,

• Wrong formula or reference cell
• Incorrect object linking or link embedding OLE
• Empty or no values in named or range cells
• Multiple Excel files (not common)

Methods to Resolve ‘Excel Found a Problem with One or More Formula References in this Worksheet’ Error

Following are a few methods that you can follow to fix Excel file that can’t be saved due to problems with one or more formula references in the worksheet.

Method 1: Check Formulas

If the problem has occurred in a large Excel workbook with multiple sheets, it’s quite hard to pinpoint the problem cell. In such cases, you can use the Error Checking option that runs a scan and checks for a problem with formulas used in the worksheet.

To run Error Checking in the Excel sheet, follow these steps,

• Go to Formulas and click on the ‘Error Checking’ button

• This runs a scan on the sheet and displays the issues, if any. If no issue is found, it displays the following message,

The error check is completed for the entire sheet.

In such a case, you can try saving the Excel file again. If the error message persists, proceed to the next method.

Method 2: Check Individual Sheet

The problem may also occur due to an issue with one of the sheets in the workbook. To find the faulty sheet and fix the problem, you can copy each sheet content in a new Excel file and then try to save the Excel file.

This will help you find the faulty sheet from the workbook that you can review. This method makes the entire process of troubleshooting Excel formula reference error quite easy and convenient.

In case the error is not fixed, you can back up the faulty sheet content and remove it from the workbook to save the Excel file.

Method 3: Check Links

When the Excel file contains external links with errors, MS Excel may display such error messages. To check and confirm if external links are causing the error, follow these steps,

• Navigate to Data Tab > Queries & Connections > Edit Links
• Check the links. If you find any faulty link, remove it and then save the sheet

Method 4: Review Charts

You can review the charts to check if they are causing the formula reference error in Excel. It may take a while based on the size of the Excel file. Sometimes, it’s not practically possible to track down which Excel chart object is causing the error. Thus, you need to check specific locations, such as:

1. Check horizontal axis formula inside Select Data Source dialog box
2. Check Secondary Axis
3. Check linked Data Labels, Axis Labels, or Chart Title

Method 5: Check Pivot Tables

To check Pivot Tables, follow these steps,

• Navigate to PivotTable Tools > Analyze > Change Data Source > Change Data Source…

• Check if any of the formula used is problematic. Sometimes small typo, such as misplaced comma, can lead to such problems in Excel. Thus, check each formula thoroughly and correct the formulas wherever needed.

Method 6: Use Excel Repair Software

When none of the methods resolve the error, then you can rely on advanced Excel repair software , such as Stellar Repair for Excel. It’s a powerful tool that is recommended by several MVPs and IT administrators for resolving common Excel errors, such as ‘Excel found a problem with one or more formula references in this worksheet.’

It repairs corrupt or damaged Excel (.xls/.xlsx) files, recovers Pivot tables, charts, etc., and save them in a new Excel worksheet. It helps Excel users, facing formula reference error, restore their Excel file without any risk of data loss, while preserving the sheet properties and formatting with 100% precision.

Conclusion

Although the error ‘Excel found a problem with one or more formula references in this worksheet’ can be resolved by using various options in MS Excel, it may lead to a partial loss of information. Thus, you must perform these operations after taking a backup of the Excel worksheet. Also, if the MS Excel options fail to resolve the problem, you can use an Excel file repair software, such as Stellar Repair for Excel. The software helps fix Excel file corruption and restores the information and data from corrupt or damaged Excel files (.xls/.xlsx) to a new worksheet.