Easy Steps to Make Excel Hyperlinks Working

Summary: This blog discusses why hyperlinks won’t work in Excel and solutions to fix it. If nothing works, try using Stellar Repair for Excel software to recover your workbook with hyperlinks and all the data intact.

Hyperlinks in your Excel file could be references to a file’s location on the computer or a location within the same worksheet. Or, hyperlinks might be pointing to a URL. Sometimes, the hyperlinks won’t work and any of the following errors may pop up on your screen on clicking a hyperlink:

‘Cannot open the specified file.’

‘This operation has been canceled due to restrictions in effect on this computer. Please contact your system administrator.’

Causes of ‘hyperlinks not working in Excel’ problem, and solutions thereof

Here are some of the possible causes behind the ‘hyperlinks not working’ issue and solutions to fix it:

Cause 1 – Change in the name of the hyperlinked file

If the file name that appears in the hyperlink text is different than the actual file name, it will prevent the hyperlink from working.

Solution – Link to the renamed file

Ensure that the links in the Excel file are updated and points to the renamed file. For this, right-click the hyperlink and select ‘Edit the hyperlink’. Next, in the hyperlink address, replace the current filename with the renamed one in the hyperlink address.

Cause 2 – File name has a pound (#) sign

When you create a hyperlink for a file in Excel, you cannot use a pound character (#) in the file name that appears in the hyperlink. That is because the pound sign is not accepted in hyperlinks and may lead to the ‘Cannot open the specified file’ error.

Note: While you can use a pound character in a file name, it cannot be used in hyperlinks in an MS Office document.  

Solution – Rename the file name and remove the pound sign

Open the file that contains the ‘#’ sign and rename it by following these steps.

• Right-click the cell containing the hyperlink that is not working, and click Edit Hyperlink.
• From the Address box, copy the address of the file you are linking to.
• Go to the location where the file is stored, right-click on the file, and click Rename.
• Remove the ‘#’ character from the name of the file.
• Go back to the Excel file, right-click on the problematic hyperlink, and choose Edit Hyperlink. Next, browse and select the renamed file.
• The renamed file without the pound sign will be added in the Address box.
• Click OK.

Now try opening the hyperlink.

Cause 3 – Sudden system shutdown causes abrupt closing of Excel

There may be a discrepancy in the data in hyperlinks when a system shut down suddenly, without properly closing the Excel file. And so, when trying to open a link, it won’t open.

Solution – Enable the option to save hyperlinks

There is an inbuilt option in Excel to update hyperlinks every time the workbook is saved. Follow these steps to enable that option:

Note: The steps may vary based on the Excel version you are using.

For Excel 2013, 2016, or 2019:

• Open Excel Workbook -> Go to File->Options->Advanced
• Scroll down to find the General tab and click on Web Options
• Web Options Window pops-up
• In the Web Options Window, go to Files Tab and select the ‘Update Links on save‘ checkbox
• Click on OK button and your option is saved

The steps are also explained in the image below:

For Excel 2007:

• Click the Office button
• Select Excel Options, then follow Step 1) to Step 5), as mentioned above and get the Excel Hyperlinks to work again.

Still unable to open hyperlinks in Excel?

If you fail to make Excel hyperlinks work using the above-discussed solutions, use an Excel repair tool to fix the hyperlinks issue. Download the Stellar Repair for Excel to repair an XLS/XLSX file and restore the hyperlinks.

See the working of the tool here:

The tool recovers all components of the Excel file including tables, charts, chart sheets, cell comments, images, formulas, and more. You can repair multiple worksheets and fix all dysfunctional Excel hyperlinks across multiple worksheets in a single workbook. Click on the workbook, select all worksheets and start repairing

Conclusion

Carefully read the possible causes behind the ‘Excel Hyperlinks not working’ issue to understand what resulted in the issue in the first place. If nothing helps, use Stellar Repair for Excel to restore the hyperlinks and save the result in a new Excel file, without interfering with worksheet properties and cell formatting.

[Fixed] Excel PivotTable Overlap Error | Troubleshooting Guide

In Excel, you need to refresh the pivot table data source after adding new data. However, sometimes, while refreshing the pivot table, you may experience an error “PivotTable Report cannot Overlap.” This issue usually appears when there are multiple pivot tables in a single worksheet. It often occurs when you try to place one pivot table on top of another or if you try to set a common cell range to multiple pivot tables. However, there are many other causes associated with the error.

Reasons for a pivot table report cannot overlap another pivot table report issue:

• Merged cells in a pivot table may cause the overlap issue
• Using the same range of cells for multiple pivot tables
• Hidden columns
• Preserve formatting option is enabled
• Modifying the pivot table using a macro that is corrupted
• Using the workbook.RefreshAll method incorrectly
• Number of pivot items goes beyond the number of cells available
• Excel file is corrupt
• Corrupted Pivot table
• Some columns are labeled with the same name

Methods to Fix Excel PivotTable Report Cannot Overlap Error

You can get the pivot table overlapping issue if the field in pivot table crossed the maximum items limit. According to the Microsoft guide, you can specify up to 1,048,576 items to return per field. Check the cell fields in your pivot table. Also, make sure each column’s label is unique. Sometimes, the hidden columns or hidden sheets can also prevent you from modifying the pivot tables. You can check for hidden columns in the Data view.

If the error still persists, then try the below-mentioned methods to fix the error.

1. Move the Pivot Table to a New Worksheet

The “PivotTable Report cannot Overlap” error can occur if there is an issue with the columns in the pivot table. In this case, you can try moving the pivot table to a new worksheet. Moving the pivot table to a different worksheet automatically resets the column width according to the new sheet and creates space that can help in preventing the overlapping issue. Here are the steps to do so:

2. Disable the Background Refresh Option

When the background refresh option is enabled, then Excel updates the pivot table in the background after every minor change. It may create issue if you have a large-sized Excel file with multiple pivot tables. You can try disabling the background refresh option. Here’s how:

• The Connection Properties dialog box is displayed. Unselect the “Enable background refresh” option and select the “Refresh data when opening the file”

• Click **OK.

  

  **

3. Disable Autofit Column Widths

When the Autofit column widths option is enabled, Excel automatically resizes the pivot table whenever you make changes to it. These automatic adjustments can sometimes add or remove fields which can result in the PivotTable Report cannot Overlap issue. To fix this, you can disable the “Autofit column widths on update” option. To do this, follow these steps:

• Right-click on any field on the pivot table.

• Select **PivotTable Options.

  

  **

• In the PivotTable Options window, unselect Autofit column widths on update.

  

• Click on the OK.

4. Check the Workbook.RefreshAll Method

Several users have reported experiencing the “Excel PivotTable Report cannot Overlap” error when using the Workbook.RefreshAll method. This method is used to refresh data ranges in the pivot report. Sometimes, the error can occur due to missing variable that is representing an object (workbook) in a query. So, make sure you’re using the Workbook.RefreshAll function correctly.

5. Repair your Excel File

You may also encounter the “A PivotTable Report cannot Overlap” error if the Excel file is corrupted. You can use the inbuilt utility in Excel - Open and Repair to repair the corrupt file. Here’s how:

• In your Excel application, click on 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 click Open and Repair.
• Click on the Repair
• In the displayed message, click Close.

If the “Open and Repair” utility fails to fix the issue, then it means there is high level of corruption in the Excel file. To tackle this, you can take the help of a professional Excel file repair tool, such as Stellar Repair for Excel. The tool can easily repair severely corrupted Excel file and recover all the objects of the file, such as pivot tables, macros, charts, etc. with 100% integrity. You can download the free trial version of the tool to check its functionality.

Conclusion

In this article, we have discussed the possible reasons behind the “PivotTable Report cannot overlap” error in Excel. You can follow the methods mentioned above to fix the issue. The error may also occur if the Excel file gets corrupted. In this case, you can try repairing the corrupted Excel file using the Open and Repair utility or consider using Stellar Repair for Excel . The tool makes the process of repairing the Excel file smooth and quick.

Fixed “Cannot Insert Object” Error in Excel | Step-by-Step Guide

Summary: The error “cannot insert object” in MS Excel can prevent you from modifying objects in the worksheet. This blog will discuss the primary reasons behind this error and the possible solutions to fix it. You will also learn about a professional Excel repair software that can help fix the error if it has occurred due to corruption in Excel file.

Many users have reported encountering the “cannot insert object” error while adding/embedding objects into the Excel file. It usually occurs when using Object Linking and Embedding (OLE) to add content (PDF, Microsoft documents) from external applications to worksheet. The error can also occur when using ActiveX control in Excel. Below, we’ll explain why you cannot insert object into Excel sheet and how to troubleshoot the issue.

Why the “Cannot Insert Object” Error Occurs?

• Macro Settings can prevent the insertion of objects into a workbook.
• The Excel file in which you are trying to add an element is corrupted.
• The object (you are inserting into the workbook) is damaged.
• Object size limitations.
• System’s insufficient memory might prevent new objects’ addition.
• Incompatible Excel file format.
• Add-ins controls are disabled.
• Incompatible or faulty Add-ins.
• Issue with Security Settings.

Methods to Fix the “Cannot Insert Object” Error in Excel

You may encounter the “Cannot insert object” error when trying to add an element stored on a network. It can occur due to issues with the file link, such as incorrect file location. In such a case, you can check the link by selecting the link to file option from the Insert tab.

Sometimes, the error can occur if the file in which you are trying to insert the object is locked and password-protected. In this case, you can unprotect the Excel file . If the issue still persists, then you can follow the below methods.

Method 1: Check and Change Restricted Security Settings

Excel provides security settings to protect your workbook. Sometimes, these settings can prevent inserting objects in the file. You can change the security settings to allow Excel to insert objects. To do so, follow these steps:

• Open your Excel application.
• Locate the File and then click Options.
• In Excel Options, click Trust Center.

• Click Trust Center Settings.
• In the Trust Center Settings window, select Protected View from the left pane.

• Under Protected View, unselect 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.
• Once you’re done with this, click on Macro Settings in the Trust Center window.
• Under Macro Settings, make sure “Disable all macros without notification” is not selected. If it is selected, then unselect it. After that, click OK.

• Restart Excel to apply the changes.

Method 2: Uninstall Microsoft Office Updates

You can also encounter the “Cannot insert object” error in Excel after installing MS Office updates. It might be due to the issues with the installed updates. To fix this, you can uninstall the recently installed Office updates. To uninstall the Office updates, follow these steps:

• Go to the system’s Control Panel.
• Click Programs and then click Program and Features.
• Search for “View Installed Updates” and click on the desired Office updates.
• Right-click on it and then click Uninstall.
• Follow the uninstallation steps on the screen.
• Once the process is complete, restart the system.

Method 3: Check Memory Usage

The “Cannot insert object” issue can also occur if your system is low on memory. You can check and close unnecessary processes and applications running in the background to free up memory. To do so, follow these steps:

• Press CTRL + ALT + DEL on the keyboard and click Task Manager.
• Click on the Processes tab and search for any unnecessary processes.
• Right-click on the process and then select End Task.
• Restart Excel to see if the issue is fixed.

Method 4: Check Excel File Size

If your Excel file size exceeds the prescribed limit, it can also lead to the “Cannot insert Excel object” error. So, check the Excel file size. You can reduce the file size by removing unnecessary objects, such as formulas or images.

Method 5: Check and Change Excel ActiveX Settings

You can get the “Excel cannot insert object” error if your Excel file contains macros, controls, and other interactive buttons. It usually occurs if the ActiveX Controls option is disabled. You can check and change the ActiveX Settings to fix the issue. Here are the steps:

• Open your Excel application.
• Navigate to File and then click Options.
• In Excel Options, click the Trust Center tab.
• In the Trust Center Settings, click ActiveX Settings.
• Under ActiveX Settings, make sure the “Enable all controls without restrictions and without prompting” option is selected.

• If the option is not selected, then select it and click OK.
• Restart the Excel and check if the error is fixed or not.

Method 6: Repair the Excel Workbook

The “Cannot insert object” error can occur if the object you are trying to insert is corrupted or the file in which you are inserting the object is damaged. If the issue has occurred due to a corrupted Excel file, then you can repair the file using the Open and Repair utility in MS Excel. To use this Microsoft-inbuilt utility, follow these steps:

• In the Excel application, go to the File tab and then click Open.
• Click Browse to choose the affected 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 Repair.

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

• Click Close.

If the Open and Repair utility fails to fix the issue, then try a professional Excel Repair software, like Stellar Repair for Excel. It is designed to repair severely corrupted Excel files. It can restore all the Excel file objects, such as tables, charts, formulas, etc. It helps fix all types of corruption related errors. The software is compatible with all versions of Excel.

Conclusion

You might encounter the “Cannot insert object” error when embedding or inserting objects in Excel. In this post, we have discussed the possible solutions to fix this error. We have also mentioned an Excel repair software that can help to easily repair the corrupted Excel file and recover all the data. You can download the Stellar Repair for Excel’s free demo version to preview the recoverable objects of the 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.

Recover Corrupted Excel File 2007, 2010 | Easy Methods

There are several reasons that can cause Microsoft Excel workbooks to turn corrupt, such as virus attack, bad sectors on a drive on which Excel file is saved, system shutdown without properly closing the Excel application, etc.

Corruption in an Excel workbook can result in data loss or render the workbook inaccessible. Fortunately, Excel automatically starts recovery upon opening a corrupted Excel file. But, if it fails, you can manually repair the file or extract data from the corrupt file.

Quick Solution: Performing 2007, 2010 Excel repair or recovery process manually can be time-consuming. Also, manual workarounds to recover corrupt Excel workbook does not guarantee recovering the complete workbook data. Use Stellar Repair for Excel software to repair single or multiple Excel (XLS/XLSX) files in 3 simple steps. The software also helps recover the Excel file, keeping the data intact.

How to Fix Microsoft Excel 2010 & 2007 Files Corruption?

Microsoft Excel comes with an inbuilt repair utility, called ‘Open and Repair’, that helps fix and recover corrupted Excel files.

Steps to Repair MS Excel 2010 Files Manually

The detailed steps to open and repair Excel 2010 are as follows:

• Open Microsoft Excel 2010 and click File from the main menu.

• Next, click Open.

• Browse the corrupt Excel 2010 file on your computer and select it in the Open dialog.

• Click the arrow next to the Open button and choose Open and Repair.

• Click Repair when prompted to recover data to the maximum.
• If Excel fails to repair, click Extract Data to extract values and formulas in the corrupt file.
• Excel prompts to ‘Convert to Values’ or ‘Recover Formulas’.
• Click Yes if it prompts the following error:

“The document file name caused a serious error the last time it was opened. Would you like to continue opening it?

• When Excel opens the last saved file, save it.

Once you’re able to access the last saved 2010 Excel file, try extracting the file contents.

Save Excel 2010 File in HTML Format

If you can open the Excel file, choose the HTML format to save it in filtered form. After that, close the Excel file as you have your data in the HTML file. The steps to save an Excel file in HTML format are as follows:

• Open Microsoft Excel 2010, click Save As, and then choose Web Page in the ‘Save as’ type drop-down list.
• Select the “Enable Entire Workbook” option, and then click the Save button.
• Close the Excel file and reopen your Microsoft Excel application. Browse the HTML file that you have saved.
• Click File from the main menu, and select Save As in the list.
• Type-in a different name, choose Microsoft Excel Workbook in the ‘Save as’ type drop-down menu, and then click the Save button.

With this, you would be able to access the data in the corrupt Excel file.

If the inbuilt tool fails to repair Excel 2010 file, a few methods can help you recover data from corrupted or lost workbook manually.

Steps to Repair Excel 2007 Files Manually

Follow these steps to repair a corrupted 2007 Excel file by using the inbuilt Microsoft Excel repair tool:

• Open Microsoft Excel 2007, click the Office button, and then select Open.

• In the Open dialog box that pops-up, browse and select the corrupt Excel 2007 file. Click the arrow next to the Open button and choose Open and Repair.

• Click Repair when prompted to recover as much data as you can from Excel 2007 file.

• If a repair fails, follow steps 1 till 3, and then click Extract Data to extract values and formulas from the corrupt file.
• In the window that appears, click Convert to Values or Recover Formulas to extract workbook data.

Note: The built-in Microsoft Excel 2007 repair tool may fail to resolve Excel corruption issue. Also, choosing to extract data from the workbook involves data loss risk. Using a professional Excel repair tool, however, can resolve all types of Excel file corruption errors and restore all its data.

Methods to Recover Data from Corrupt Excel 2010 & 2007 Files

If the ‘Open and Repair’ feature fails in getting your Excel 2010, 2007 file repaired, you can try retrieving the file contents by following some manual methods. However, the methods may vary depending on whether you can open a workbook or not.

Method 1 – Move Corrupt Excel File to another System

Move the corrupt Excel file to any other computer and try opening it in MS Excel 2010/2007. Doing so, may help you resolves disk or network-related errors leading to Excel file corruption.

Method 2 – Revert Unsaved Excel File to its Last Saved Version

If an Excel file turns corrupt while working on it but before saving any changes, try reverting it to its last saved version. To do so, perform the following:

• Open your Excel application, click the Office button, and then click Open from the menu.
• Browse the corrupt Excel file, click Yes when prompted to revert to its last saved version.

What if Nothing Works?

If you fail to recover a corrupt Excel 2007/2010 file, perform Excel file recovery with Stellar Excel repair software. The software is specially designed to help users fix their corrupted XLS/XLSX files quickly and easily without any technical assistance. It also helps restore all the file data to its original form.

Points to Remember

• Close all the MS Excel instances before using the software
• If the sheet you are repairing contains engineering formulas, please include ‘Analysis TooPak’ manually from Tools > Add-Ins

If you know the corrupt Excel 2007 or 2010 file location, click Browse to choose the file. Otherwise, click Search. Follow the below steps to recover data from corrupt Excel 2007/2010 file by using Stellar Excel repair tool:

• Click the Repair button to scan the file.

• Once the scanning process is complete, the software shows a preview of recoverable Excel file items.

• To save the repaired file, click the Save File option on File menu.

• In ‘Save File’ dialog box, choose to recover Excel 2007 & 2010 data to either the Default or New location. Click OK.

The repaired Excel file gets saved at the specified location.

Preventive Measures to Avoid Losing Excel File Data

The above-discussed methods might help salvage your data. But, it is recommended that you must take some preventive measures to avoid losing the data. One such important measure is backing up a copy of your workbook automatically. Doing so, will help you get back data in case the workbook is accidentally deleted or corrupted.

Steps to Create Backup Copy Automatically

You can automatically create an Excel backup copy by following these steps:

• Click Save As from the main menu of your Excel application.
• Browse to the location where the corrupt Excel 2010/2007 file is saved.

• In ‘Save As’ dialog box, click the arrow next to Tools button (given at the bottom left corner) and choose General Options.

• In ‘General Options’ box, check Always create backup checkbox, and then click OK.

With this, you instructed MS Excel to create a backup of every Excel file you create or open for work.

Conclusion

This article outlined the typical reasons resulting in a corrupt Excel 2010 or 2007 file, such as virus infection, bad sectors on drive, etc. It explained how to fix a corrupted Excel file by using the inbuilt MS ‘Open and Repair’ tool. The article also discussed methods to recover Excel files in MS Office 2010 & 2007 when the Microsoft Excel repair tool fails. Further, it explained how using a professional repair tool such as Stellar Repair for Excel can come in handy when the manual methods to repair and recover Excel 2007 and 2010 file fails. But, keep in mind, a workbook may get corrupt again. And so, make sure to automatically backup your workbook to avoid losing its data.

[Error Solved] Excel file is not in recognizable format

Summary: Microsoft’s Excel is one of the most widely used spreadsheet tools, however, it isn’t entirely free of errors. There are in fact quite a large number of problems that can crop up in this user-friendly application which can put all work to halt. One such error occurs when Excel does not recognize the file format of .xls or .xlsx file and the error message says “Excel file is not in recognizable format” error. Let us explore this annoying error in detail.

Figure: Error message

From a small shop to the global industry giants, everyone relies on Microsoft Excel to complete their work. Quite a few businesses not only use Excel for their inventory tracking purposes but also to manage task lists and timesheets for their employees and project management charts. With high programming proficiency, one can create macros in excel which help in automating a lot of things. You can create quite a few variations, such as pie charts, bar charts, line graphs, area charts, and many more to showcase the data both in a tabular column as well as in a pictorial representation.

While Excel enjoys wild popularity, thanks to its powerful design and features, it doesn’t mean that Excel is all free of errors. There are actually repetition a few errors that one can encounter. One you might have come across is the error stating “Excel file is not in a recognizable format”.

What is this error all about?

The “Excel file in unrecognizable format error” occurs when the Excel file you are trying to load is corrupted. Microsoft has ensured that the workbook will be recoverable when the file is imported into excel but there are times when the automatic recovery does not happen. That’s where the challenge really lies. In such cases, getting to the root of the issue becomes necessary to be able to solve it.

Reasons behind the error

1. One of the main reasons for the error is that the file must have got corrupted while being transferred from one machine to another.
2. Another reason can be that the latest service pack might not be in use on your system.
3. There could be MS Excel version change.
4. Corruption of the file due to virus infection, extremely large databases, or multiple locks on the file at the same time can also trigger this error.

If you have ever faced this error, you do not need to panic. We have a couple of solutions listed for you when you face the Excel file in an unrecognizable format error.

How do you go about fixing this?

Solution 1: Use MOC.exe file to convert the workbook and then open it in Excel:

1. Right-click on .XLS (you can use any .XLS files in your system).
2. A new dialogue will appear. Here, click on “Choose another app” to select it.

Figure: choose another app

3. You will now be presented with a number of applications which the OS thinks the file format will be compatible with.
4. You do not have to choose any of the prepopulated apps from the list.

Figure: Look for another app

5. Navigate using the Look for another app on this PC  to the path “C:\Program Files\Microsoft Office\OfficeVersion”
6. You will see a file name MOC.exe
7. Choose that and complete your export.
8. Try opening the workbook in Excel and the error should now be resolved.

Solution 2: Opening the file from within the Excel:

1. Open a new Excel workbook.
2. Press “Alt + F” or alternatively, go to the menu.
3. Once you are in the menu, go to Options.
4. You will be able to see a number of tabs on the left side of the options.
5. Under the ‘Formulas’ tab, ensure that the calculation is in Manual mode – this setting is in the automatic mode, by default.

Figure: Manual option

6. Click OK and save the changes to the workbook.
7. Now, browse for the file which was corrupted.
8. Click on the file and then select the option “Open and Repair”. You will find it in the drop down Menu.

Figure: Open and Repair

9. Once the file has been imported, click on “Repair” to recover the data from the selected workbook.

Figure: Repair option

Solution 3: Use automated Excel repair software

If none of the above mentioned manual methods works to eliminate the ‘Excel file in unrecognizable format’ error, it means your Excel file has been severely corrupted and needs professional assistance. In such a scenario, quickly download reliable and competent software Stellar Repair for Excel. Backed by powerful scanning and repair algorithms, this product guarantees up to 100% Excel file repair regardless of the amount of damage in it.

1. Download, install and launch Stellar Repair for Excel.
2. Allow the software to scan the corrupted Excel file.
3. All recoverable data will be listed in a tree-view list. You can select and preview any item from here.
4. Select and recover individual or entire data from the file and save as a new Excel.

This method is currently the easiest and most convenient to resolve miscellaneous Excel errors.

Wrapping it up

Excel is one of the most powerful tools which can easily reduce your workload by more than 75% if used in a proper way. However, if you face complex errors like “Excel file is not in recognizable format”, you can use the methods mentioned above to get rid of it and resume your working in MS Excel. Remember, if the manual solutions don’t work, you can always rely on a proficient software like Stellar Repair for Excel to complete the job with finesse.

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.