Data Disappears in Excel - How to get it back

Summary: You may face the issue of ‘Excel spreadsheet data disappeared’ after changing Excel file properties and formatting rows and columns. This blog discusses the possible reasons for data disappearance and the solutions to fix the issue. Also, it mentions an Excel file repair tool to retrieve the data from the file. Sometimes, while editing or formatting a cell in an Excel spreadsheet, the data may go missing or disappear. Let’s discuss in detail the reasons that may cause the ‘Excel data disappeared’ issue along with the solutions.

Probable Reasons for Data Disappearing in MS Excel and Solutions Thereof

Click here

### Reason 1 – Unsaved Data

While entering data in an Excel spreadsheet, it is important to save the data at frequent intervals. Doing so prevents any unsaved data from disappearing if you lose power or accidentally click ‘No’ when prompted to save the file. Unfortunately, such a situation is quite common as users often close the file without saving the recently made changes to a spreadsheet.

Solution – Use the ‘AutoSave’ Feature

With the AutoSave feature enabled in Excel, data won’t be lost in the event of power failure or abruptly closing the Excel program. By default, Excel automatically saves the information in a spreadsheet after every 10 minutes. You can reduce the limit to a few seconds to reduce the chances of Excel file data lost after being saved.

Reason 2 – Changing Excel Format

You can save an Excel file in various formats, like spreadsheet, text, webpage, and more. However, at times, saving the spreadsheet in a different format may lead to missing data. For example, when you save a workbook to a text file format, all formulas and calculations applied to the data will be lost.

Solution – Adjust a Spreadsheet for the Changed Format

If you’re changing the format of a spreadsheet, make space for the rows and columns. Also, remove all calculations before saving the file.

Note: If the sheet is shared on multiple computers, then save the file in compatibility mode.

Reason 3 – Merging Cells

You can combine two or more cells data to make one large cell. This technique is primarily used to fit the text of a title in a sheet. If there is data in two or more cells, then only the data in the top-left cell is displayed and the data in all other cells is deleted. If the other merged cells have been populated with data after merging, the data is not featured and it does not appear even after remerging the cells.

Solution – Merge Cells inside One Column

To merge cells without data loss, combine all the cells you want to merge within a column and do the following:

• Select the cells to be combined.
• Ensure that column width is wide enough to fit the contents of a cell.
• In the spreadsheet, under the Editing group, click ‘Fill,’ and then click ‘Justify.’

• Under Alignment, click on the ‘Merge & Center’ option to center align the text. Or, click on ‘Merge Cells’.

Note: This solution works for text only. You cannot use it to merge formulas or any numerical values. If you need to combine two or more cells with formula into a single cell, try using the Excel CONCAT function .

Reason 4 – Cell Formatting

Cells and text in the cells can be displayed in different colors to make the spreadsheet simple to create and infer. You may experience data loss when you try to modify the data or change the color or size of the data. Though the information may exist, the data may show an error due to the following reasons:  

• White-colored text will not show in a white-colored cell
• Large font-sized data may not appear in small-sized cell
• Calculations may show (#VALUE) error after cell-formatting

Solution – Check and Clear Formatting

Make sure to use dark-colored text on a white-colored cell. Also, resize the cell to fit the text size. Check if numbers in a cell are entered as text. If so, you need to apply a number format to the text-formatted numbers. Read more about it, from here .

What Else You Can Do to Resolve the ‘Excel Data Disappeared’ Issue?

If you can’t recover the missing Excel file data, try to repair or extract the data from the file using the built-in Excel repair tool. Follow the below steps to use the tool:

• Open MS Excel, click File > Open > Computer > Browse.
• On the ‘Open’ window, select the file you want to repair and then click on the Open dropdown.
• Select Open and Repair.

Use the ‘Repair’ option to repair the file and recover as much data as you can from the repaired file. If this doesn’t work, use the ‘Extract’ option to recover the data.

If you fail to retrieve the disappeared data from that file using the above-listed steps, opt for an Excel repair tool , like Stellar Repair for Excel. This software has a proven track record of repairing corrupt or damaged Excel files and recover all the data.

The software helps:

• Fix all corruption errors. It helps in getting back the data which has disappeared.
• Repair a single as well as multiple Excel files.
• Recover all components of XLS/XLSX files – tables, chart sheet, cell comment, image and more.
• Preserve the worksheet properties and cell formatting.
• Support the latest Excel 2019 and earlier versions.

The Excel repair software repairs the Excel file in these simple steps:

• Launch and open the software.
• Select the corrupt Excel file by using the ‘Browse’ option. If the file location is not available, then find the Excel file using the ‘Search’ option.

• Click ‘Repair’ to scan the corrupt file.

• Once the repair process is complete, verify the components of Excel file and check if the available preview shows complete data that disappeared from Excel.

• Save file at default location or preferred location.

The Excel file with all the restored data will be saved at the selected location.

Conclusion

It is better to repair the affected Excel file than suffer the loss when data or text disappears in Excel. A professional software ensures that users get back all the data in the form of a new Excel file. Stellar Repair for Excel software repairs the corrupt file without modifying the original content and file format. The software’s easy-to-use user interface lets you perform the functions without formal software training and technical expertise.

How to Repair Multiple Excel Files by Using Stellar

With Stellar Repair for Excel, it is quite easy and simple to repair multiple MS Excel (XLS and XLSX) files that are damaged. This is because the software has a self-explanatory interface and hence is a Do-it-yourself software. Nonetheless, when using this software to repair multiple Excel files, you would have to add all of the files into the software by following a few pre-defined steps. Follow the steps mentioned below:

• Launch Stellar Repair for Excel software.
• Under Home menu, click Select file

• Click Browse and select corrupt Excel files. Select the checkbox to repair multiple files.

• Click Repair
• The software provides the preview facility. You can check the it on left pane.

Click here


• Save the repired filr ether Default location or Select New Folder radio button.

Stellar Repair for Excel Stellar Repair for Excel is the best choice for repairing corrupt or damaged Excel (.XLS/.XLSX) files. This Excel recovery software restores everything from corrupt file to a new blank Excel file.

Learn More

Simple ways to Open Corrupt Excel file Without any Backup

Summary: The blog describes simple ways to open corrupt Excel file without any backup. It explains some manual workarounds that you can try to open the file. Also, it mentions about an Excel file repair tool that can quickly fix the corrupt file and recover data from it.

Do you have an Excel file that does not open because of corruption issue? And every time you try to open it, an error message ‘the file is corrupt and cannot be opened’ pops-up?

Excel File Corruption Message

Also, you don’t have a healthy backup of the Excel file to restore the data? If so, you can try repairing the corrupt file by using a few simple yet effective manual workarounds mentioned below.

How to Open a Corrupt Excel File without Backup?

Following are some manual methods that can help you open a corrupt Excel file:

Method 1: Repair Corrupt Excel File

When attempting to open a corrupt file, Excel automatically starts ‘File Recovery’ mode to repair the file. But, if the recovery mode doesn’t start, try Microsoft Excel’s built-in ‘Open and Repair’ feature to manually repair the file.

To use this feature, perform the following steps:

Step 1: Open a Blank workbook in Excel, and then click File > Open.

Step 2: In the Open window, browse and select the corrupt file.

Step 3: Click the arrow that is beside the Open tab, and select Open and Repair.

Open and Repair Option

Step 4: Implement one of the following:

• Click the Repair button. (This is to recover as much data as possible.)
• Click the Extract Data button. (This is to recover values and formulas from the Excel file if the repair process fails to recover the entire data.)

Excel Built-in Repair Options

If using Open and Repair does not work , move to the next method.

Method 2: Disable the Protected View Feature

Some Excel users have reported that turning off the ‘protected view’ feature in Excel helped them open the corrupt file. You can also try to disable this feature and open the file. To do so, follow these steps:

Step 1: Open a blank Excel file, click on File > Options.

Step 2: In the Excel Options window, select Trust Center, and then click Trust Center Settings.

Excel Trust Center Settings

Step 3: Click OK.

Now check if you can open the corrupt file. If not, try implementing the next method.

Method 3: Look For Automatically Recovered Excel File

If you have Excel’s AutoRecover feature enabled, you’ll have access to a copy of the Excel file corrupted or lost due to application crash, power outage, or accidental deletion.

The ‘AutoRecover’ feature saves Excel worksheets at a temporary location after a certain time interval. It saves the worksheets automatically and is turned on by default to reduce the chance of data loss.

Check if you can recover corrupted Excel file by following these steps:

Step 1: In Excel, open a Blank workbook.

Step 2: Go to File and click Options.

Figure 5 – Excel Options

Step 3: In the Excel Options dialog box, click Save, and then copy the ‘AutoRecover file location’.

Excel Options Window

Step 4: Open File Explorer window and paste the copied AutoRecover file location, and press Enter.

Step 5: A list of saved Excel files will be displayed. Choose the file you want to recover.

TIP: Use Excel’s AutoBackup feature to reduce chances of data loss, by saving a previous version of your spreadsheet automatically.

Use an Excel File Repair Software

If the above manual methods fail, repair the corrupt Excel file by using a third-party software, such as Stellar Repair for Excel**.** The software helps repair Excel (XLS and XLSX) files easily and effectively.

Click here

[](https://tools.techidaily.com/stellardata-recovery/repaire-for-excel/)

Read this: How to repair corrupt Excel file using Stellar Repair for Excel?

Some key features of Excel Repair software are as follows:

• Fixes all errors in the MS Excel file.
• Repairs multiple damaged Excel files in a go.
• Recovers chart, chart sheet, table, cell comment, image, formula, and sort & filter.
• Preserves properties and cell formatting of Excel worksheets.
• Previews recoverable Excel file data before saving.
• Recovers all data components from the corrupt files and saves them in a new blank Excel file.
• Compatible with Excel 2019, 2016, 2013, 2010, 2007, and lower versions.

Conclusion

You can try the workarounds discussed in the blog to open a corrupt Excel file without a backup. Disabling the protected view feature can help you open the file. If the issue persists then try repairing the corrupted Excel file using the Open and Repair utility. Although, it may not be able to fix a severely corrupted workbook. In such a case you can use Stellar Repair for Excel . It is an advanced tool that can help you repair a corrupted Excel file with 100% integrity.

How Do I Repair and Restore Excel File?

When an Excel file turns corrupt, the file might become inaccessible or you might receive errors. You may encounter errors, such as ‘the file is corrupt and cannot be opened,’ ‘Excel found unreadable content in “filename>”,’ ‘Excel cannot open “filename” because the file format or extension is not valid,’ etc.

Common Reasons for Excel File Corruption

There are several reasons that can turn the file corrupt. The most common reason is a damaged hard drive. Other factors that can cause corruption in an Excel file are as follows:

• System crash or abrupt shutdown of the system while the file is still open
• Viruses infecting the file with malicious code
• Bug in the operating system
• Bad sectors on the drive where the file is stored
• Large spreadsheets with formulas and other components

Whatever be the reason, if your business is dependent on an Excel file, corruption in the file could hamper your business continuity. Also, you may lose crucial data. In such a situation, you could try to repair the file.

Before We Begin

It is important to identify the root cause behind Excel file corruption. If the problem has occurred due to a faulty hard disk drive, contact your hardware vendor to get it fixed. Also, move the file to another local drive and check if it opens. If nothing works, proceed with the methods discussed below to repair and restore the file.

Methods to Repair and Restore Excel File

Try the following methods to fix corruption in an Excel file and restore it.

Method 1 – Use the Built-in ‘Open and Repair’ Tool

You can use the Excel built-in Open and Repair utility to repair the corrupt file. Follow these steps:

• Open your Excel application and click on Blank workbook.

• On the blank workbook screen, click on the File tab.

• Click Open > Computer > Browse.

• Select the file you want to repair and then click on Open and Repair from the Open dropdown box.

• Click Repair to fix corruption in the Excel file and recover maximum data.

• If you get the following error message, click Yes to open the file.

• If clicking Yes opens the file with garbage entries (see the image below), perform Step 1 – 5 and click Extract Data. This will only help you recover data without formulas and values.

Note: You may also try to recover the data from a corrupted workbook by using the methods suggested by Microsoft .

A better way to repair and restore an Excel file with complete data is to use a specialized Excel file repair tool .

Method 2 – Use Excel File Repair Tool

Stellar Repair for Excel is a powerful tool designed to help users fix corrupted .xls or .xlsx files without any technical assistance. Also, the tool recovers all the components from a corrupted workbook, including tables, pivot tables, cell values, formulas, charts, images, etc. You can preview the repaired file and its contents by downloading the free demo version from the link below. It is a useful feature that allows the user to validate the data before saving it.

[

](https://tools.techidaily.com/stellardata-recovery/repaire-for-excel/ “Free Download For Windows”)

Here’s the step-by-step instructions to repair a corrupt Excel file using the software:

• Run the software. The software main interface opens with an instruction to add some add-ins if you’ve engineering formulas in the file you want to repair.

• Click OK to proceed.

• Select the file you wish to repair by using the Browse option.

Note: If you’re not aware of the file location, choose the ‘Search’ option to locate the file.

• A screen showing progress of the Excel file repair process is displayed.

• Preview of the repaired Excel file and its recoverable data is displayed.

• After verifying the data, click on the Save File button on the File menu to save the repaired file.

• Select the location where you wish to save the repaired file on the Save File window and then click OK.

A confirmation message will pop-up after completion of the repair process. You can now try to open the file in your Excel program.

End Note

Even if you’re taking preventive measures, you might still experience corruption in an Excel file. So, it’s crucial to take regular backups of your workbooks. For this, ensure that the ‘Always create backup’ option is enabled in Excel. You can find it in General Options by clicking on the Tools button in the Save As dialog box. Enabling it will ensure that the Excel backup file is updated with the changes made in a spreadsheet.

Additionally, ensure that the Excel ‘AutoRecover’ feature is set to save a version of your Excel file after every 10 minutes. You can increase or shorten the interval as per your requirement.

How to Fix “File Not Loaded Completely” Error in Excel?

Summary: You may get the “File not loaded completely” error when opening a large-sized Excel file. Read this post to understand the causes behind this issue and the troubleshooting solutions to fix this Excel error. Also, you’ll get to know about an Excel repair tool that can help fix the issue if the cause is corruption in the Excel file.

Several users have reported experiencing the “File not loaded completely” error while opening Excel spreadsheets or when importing CSV file into Excel. This error can occur if the worksheet has crossed the maximum rows and columns limit , i.e., 1048576 rows by 16,386 columns. However, this issue can also occur due to various other reasons. Let’s take a look at the possible causes behind this error.

Why this Error Occurs?

The “File not loaded completely” issue can occur due to one of the following reasons:

• The Excel file you are trying to open is corrupted.
• The Excel file is too large.
• The Excel file has crossed the rows limit.
• Memory issue in your system.

Methods to Resolve the “File not Loaded Completely” Error

Following are some methods you can try to fix the Excel file not loaded completely issue.

Method 1: Try to Import the Spreadsheet into MS Access

A large-sized Excel file takes time and memory to load. When you try opening a large file, you may get the “file not loaded completely” error. It indicates your file contains unwanted rows and columns. In such a case, you can try importing your spreadsheet into Access. By doing this, you can easily access the rows and columns in the database table, and then remove the extra rows. Follow the steps below to import your spreadsheet into Access:

• Open a blank database in Access application.
• Navigate to the External Data tab and then click on the Excel button.

• In the Get Data-Excel Spreadsheet window, click Browse.

• In the File Open dialog box, select the Excel file (in which you are getting the error) and click Open.

• Select Import the source data into a new table in the current database and click OK.


• In the Import Spreadsheet Wizard window, you’ll see all the rows and columns of your Excel file. Click Next.

• In the dialog box that appears, you can modify the field information (extra columns or rows).

• Once you performed the changes, click on the Next button.

• Provide a name to the table.

• Next, select the option “I would like a wizard to analyze my table after importing the data” (if you want to analyze the data) and click Finish.
• You will get a dialog box with a message. Click Yes.
  
• The Table Analyzer wizard will appear on the screen.

• Click on the Next button.

• Follow the instructions of the Table Analyzer wizard.
• Once you complete all the steps, select “Save import step” and click Close.

Method 2: Split Your Large Excel File

You may face the Excel file not loaded completely issue when importing a large Excel file. In such a case, you can try splitting your large file into smaller ones. To split the file, you can use VBA codes or the move or copy feature.

Method 3: Stop Unwanted Processes Running in the Background

Sometimes, you get the “File not loaded completely” error if you are running multiple files or programs simultaneously. You can check and stop unnecessary background processes in Windows using your system’s Task Manager. Here are the steps:

• Press the Ctrl+Shift+Esc keys to open the Task Manager window.

• Navigate to the Processes tab and check the Memory section.
• You can see the memory consumption of all the applications in your system.
• Select the unwanted applications and click on End Task.

Now, try to open the Excel file.

Method 4: Repair your Excel File

Sometimes, Excel throws the “File not loaded completely” error if it fails to read the data in your file. This might happen if your Excel file is corrupt. You can use the Open and Repair utility in Excel to repair your Excel file. Follow the below steps:

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

•  Click on the Repair button.

• After repair, you will see a message as shown in the below figure.

• Click Close.

An Alternative Solution

If your file gets corrupted, then repairing it using the “Open and Repair” utility is a good option. However, the Open and Repair utility may not work if the file is severely damaged or corrupted. In such a case, you can use a professional Excel repair tool, such as Stellar Repair for Excel. This tool is primarily designed to repair inaccessible or corrupted Excel files. It can effectively work even if your file is too large or severely damaged. It can recover all the data from the corrupted Excel file without impacting its actual format. The software supports Excel files of almost all Excel versions.

Parental Control Software

#1 Rated Parental Control Software.
Monitor & Control all PC Activity!
sentrypc.com/parental-controls/ ## **Conclusion**

The File not loaded completely issue in Excel may occur due to numerous reasons. Try the troubleshooting methods listed above to resolve the issue. If the Excel file is corrupt, then you can try repairing your file using the Open and Repair tool. However, it can fix only minor corruption issues. If your file is severely corrupted, then use Stellar Repair for Excel . The software offers you the safest way to repair your Excel file without making any changes in the formatting. You can download the free trial version of the software today to scan and preview the Excel file.

Solutions to Repair Corrupt Excel File

Summary: MS Excel can throw various errors due to corrupted Excel files. This blog discusses the error messages that indicate Excel file corruption and the methods to prevent data loss due to a corrupt file. It also discusses the reasons behind the corruption in Excel file and their solutions. It also mentions a “Stellar repair for Excel” tool that can help to repair the corrupt or damaged Excel file.

Is your Excel file corrupted? And you don’t have backup of your data? There is no need to worry. There are some simple solutions to repair Excel file 2019. But before heading towards the solutions, let’s discuss the possible reasons for Excel file corruption and how you can prevent losing your data.

Error Messages that Indicate Excel File Corruption

When an Excel file gets corrupted, different error messages appear. For example:

• “Excel found unreadable content in . Do you want to recover the content of this workbook, click Yes.”
• “Can’t find project and library.”
• “The workbook cannot be opened or repaired by Microsoft Excel because it is corrupted.”
• “Microsoft Excel has stopped working.”

Reasons Behind Excel File Corruption

The reasons for corruption in Excel file could be any of the following:

• Improper system shutdown
• Computer virus/malware attack/Hacker attack
• Outdated anti-virus definition
• Hardware failure
• Unintentional deletion of files
• Large Excel files
• Bad sectors on storage media

How to Avoid Data Loss Due to Excel File Corruption?

Excel users should follow the below precautionary measures to prevent data loss due to Excel file corruption:

1. Create an Automatic Backup Copy

When you create an Excel spreadsheet, it is advised to Save As your document, as follows:

1. In Save As window, click Tools next to Save option.
2. Select General Options from the drop-down menu.
3. Then check the dialogue box Always create back up and click OK.

This will always create a backup of your Excel. If it’s deleted or corrupted at any time, it can be recovered.

2. Create Recovery File at Different Time Periods

Steps are as follows:

1. Go to File and then click Excel Options.
2. Click Save and then select the Save Auto Recover information every checkbox
3. Add the required minutes and location. Ensure that Disable AutoRecover for this workbook only box is unchecked.

Methods to Repair Corrupted Excel 2019 File

Try using these 5 methods to restore your Excel file and recover data:

Method 1: ‘Open and Repair’ Excel Files

Excel automatically opens the corrupted file in Recovery Mode. If not, you can repair Excel file manually through the following steps:

• Click on the File and select Open.

• Go to the location where the corrupt workbook is stored. In the Open window, select the corrupt file.
• Click Open and then select Open and Repair.
• In the window that opens, click Repair.

If the Repair option doesn’t work, you can select Extract Data and try to extract the values and formulae safely from the corrupt file.

Method 2: Recover Data from Open Workbook

If you face issues while working in an Excel file, you can choose to return to the last saved version of the Excel file. For this:

• Click File. Then select Open.
• Double click on the name of the workbook (the one that is open in your Excel).
• Click Yes to reopen it.

• The workbook will now appear.

Please note that it will show the last saved version and changes made after that won’t be recovered.

Method 3: Set Calculation Option as Manual

You can also recover data from Excel workbooks that you’re unable to open. For this, you need to configure the calculation option as manual in Excel. You can do this through the following steps:

• Click on File. Select New and open a Blank workbook.
• From File, select Excel Options.

• From the Formulas category, under the section Calculation options, select Manual. Now click OK.

• Then click File, and select Open to open the corrupted or damaged Excel file.

Method 4: Recover Content by Using External Links

You can also recover specifically the content (leaving formulas/calculated values) from the workbook by using external references (to link Excel workbook). For this:

• Click on File, Select Open.
• Navigate to the folder that contains the corrupted workbook.
• Now, right-click on the file name of the corrupted workbook and click Copy.
• Click File button. Then, select New and create another blank workbook.
• In the first cell (A1), type =!A1 and press Enter.
  • Select the corrupted workbook in the Update Values dialogue (if it appears). Then click OK.
  • Select the relevant sheet in the Select Sheet dialogue (if it appears). Then click OK.

• Again, select the cell A1, go to Home and select Copy.
• Now select (start from the cell A1) an area equal to that of the data in the original workbook.
• Go to Home now and select Paste.
• Again, go to Home, and Copy the data (the same selection of cells).
• Go to Home, and then click on the arrow below Paste. Then click on Values.

By pasting values, you removed the links to the corrupted workbook and only the data is left behind.

Method 5: Excel Repair Software

If the above-mentioned methods do not help in repairing the corrupt Excel file, try an Excel repair software.

One of the most commonly used Excel repair tools is Stellar Repair for Excel. Its trial version is available for free download, which lets you scan and preview the repaired Excel files. Once you’ve ascertained the effectiveness of the software, you can save the file after activating the software.

Here’s the complete repairing process of the corrupt Excel file

Conclusion

This post shared the reasons behind Excel file corruption and precautionary measures to prevent data loss. It also outlined different methods to repair corrupt Excel file 2019. There are several in-built utilities in Microsoft Excel to repair corrupt workbooks and recover data from it. In case these methods didn’t work, you can use Stellar Repair for Excel – an easy-to-use DIY tool that can fix all Excel corruption errors and restore data with all original properties.

[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.