How to fix Microsoft Excel has stopped working error?

Summary: This blog discusses the possible reasons behind ‘Microsoft Excel has stopped working’ error and solutions to resolve the error manually. You can use Stellar Repair for Excel to quickly repair the file and recover all its data in a hassle-free manner.

Has your Microsoft Excel program stopped working or is acting strange? Excel not responding is a common issue you may experience on launching the application or opening a spreadsheet.

Figure 1 – Microsoft Excel Has Stopped Working Error Message

Possible Causes behind ‘Microsoft Excel has Stopped Working’ Error, and Solutions Thereof

Note: Several users have reported about encountering the ‘Excel has stopped working’ issue on Windows 10, 8, and 7 OS after installing an update for Excel (KB3118373). If you too have installed the update, then uninstall it and check if it solves the error. For detailed information, refer to this link .

How to fix Microsoft Excel not responding error and save your data

Summary: This guide helps you resolve Excel not responding and frequent Excel freeze issues in Excel on Windows 10. It mentions some effective solutions to repair Excel and resolve Excel is not responding problem. These solutions will also help you fix Excel crashing problem while working on the spreadsheet.

Similar to any other program, you may experience problems with Microsoft Excel while opening or working on a document. Sometimes, it may not start at all or freeze and display an error message such as ‘Excel is not responding’. When it happens, you may want to wait for the program to respond.

‘Microsoft Excel is not responding’ problem

Tip: If you are experiencing Excel not responding problem with a particular Excel file, it’s quite possible that the file is corrupt or partially damaged. And thus, leading to an Excel freeze or crash problem. Use Stellar Repair for Excel software to quickly repair and restore Excel (.xls/.xlsx) file in its original, intact form. You can download the free trial version of the software from the below link.

But if Excel doesn’t respond after a while and remains stuck, you need to force close the program from “Task Manager”. Now, this could be disastrous if happens while you are working on an important Excel document that took you hours to prepare. Force closing Excel due to such error can damage the Excel document and it may fail to open next time.

Why Excel is Not Responding?

Excel may stop responding, freeze, or crash suddenly due to several reasons. It can happen while saving a spreadsheet or opening an Excel document. It may also occur while editing or inserting images, graphs, etc. But usually, it occurs when the system crashes or shuts down abruptly while you are working on a document. Here’s an instance,

Suppose, you worked overnight on a critical document which is to be presented at a meeting the next day. This Excel spreadsheet includes critical graphs and charts, and much more. When you are about to save it, there is a power failure, and your system shuts down without warning. When the power is up, you restarted the system to check your Excel. To your dismay, a message pops up – “Excel Crashed” or “Microsoft Excel not responding”.

This could be frustrating. However, there is no need to despair as there are solutions to not just overcome this error but other corresponding issues such as Excel freezing, hanging, crashing, etc. Below is an infographic that quickly briefs all the possible solutions to fix Excel not responding error.

Solutions to Fix ‘Microsoft Excel is not responding’ Error

Follow the solutions discussed below in the given order to fix Excel freezing and hanging issues.

Solution 1: Open Excel in Safe Mode

If Excel is not working as intended and frequently stops responding, you may try to start Excel in Safe Mode. It is a common DIY way to fix ‘Excel is not responding’ problem.

In Safe Mode, Excel starts with only essential services, bypasses certain functionalities and doesn’t load the add-ins, which might be the reason behind the error in MS Excel . To open and troubleshoot Excel in Safe Mode:

Press Windows + R keys, type excel.exe /safe and press ‘Enter’ or click ‘OK’

MS Excel in Safe Mode

Open the Excel file and check if it still crashes. If not, the problem could be a faulty add-in or formatting and styling error.

Proceed to the next solution to check and fix the problem.

Solution 2: Check for Faulty and Unwanted Add-ins

In Microsoft Excel, there are two types of add-ins:

COM add-ins
Other Add-ins Installed as XLAM, XLA, or XLL File

Both types of add-ins can cause the freezing problem in Excel . Follow the steps below to disable unwanted and faulty add-ins:

In Excel , click File and go to Options to open ‘Excel Options’ window
Click Add-ins button to view and manage ‘Microsoft Office Add-ins’
Uncheck required add-ins to disable them
At this stage, you can also click the ‘Remove’ button to remove any unwanted add-ins

Disable COM Add-Ins

Now enable an add-in and check the Excel performance. Observe Excel for not responding error or freezing problem

If Excel doesn’t freeze, enable subsequent add-in and then again use Excel to observe it. Repeat the steps until you find the faulty plugin, which is causing the problem.

Then remove it from Excel add-ins to resolve the problem.

Solution 3: Install the latest Windows and Office Updates

This problem may also occur if Windows and MS Office are not updated. Therefore, install the latest updates for both Microsoft Windows and Microsoft Office.

You can set the installation and update option to ‘Automatic mode’ in Windows. This will download and install critical updates for MS Office, which might fix the Excel performance issue. The steps to enable automatic updates are as follows:

Go to Settings> Update & Security> Windows Update

Enable Automatic Windows updates

Click Advanced options and enable all the toggle switches to automatically download and install updates for Windows and other Microsoft products

Update Microsoft Products

After update, restart Excel and check if the problem is resolved.

NOTE: From now on, MS Excel will also get the latest update consistently, without the need for manual intervention.

Solution 4: Check and Disable Anti-virus

Antivirus is important for device safety. However, if your antivirus conflicts with MS Office apps such as Excel, it could lead to Excel freezing and not responding errors.

To check if the problem is due to anti-virus, disable it and reopen the Excel document. Check if Excel performs well or if it still hangs.

Example of Antivirus conflict with Microsoft Excel

If the problem is resolved, contact your antivirus software provider for help to keep antivirus running without affecting the system and other programs such as MS Excel.

Solution 5: Change the ‘Default Printer’

Although it may seem irrelevant, changing the default printer is another easy and effective solution to overcome the error. Reason being, Excel communicates with the printer to find supported margins when we open an Excel sheet.

If Excel doesn’t find the supported margin, it may stop responding or crash. The steps to change the default printer are as follows:

Open Control Panel on your Windows system
Click Printer and Devices
Right-click Microsoft XPS Document Writer to set it to the default printer

Change in Default Printer Setting

Reopen the Excel document to check whether the error occurs or not.

Solution 6: Repair Microsoft Office

A corrupt or damaged Microsoft Office can also cause the ‘Excel is not responding’ problem. You can resolve this by repairing the Microsoft Office files. The steps are as follows:

Close all running MS Office programs
Go to Control Panel on your Windows system
Click Programs and then Programs and Features
Select Microsoft Office and in the Microsoft Office window, click ‘Change’
Then select the ‘Repair’ option and click ‘Continue’

Repair MS Office

This may take a while. After the repair is done, check your Excel program and file for the error.

Solution 7: Remove and Reinstall Microsoft Office

Sometimes, repairing MS Office may not work. In such a case, removing and reinstalling Microsoft Office can resolve the ‘Excel is not responding’ problem. To do so, follow these steps:

Close all running MS Office programs
Go to Control Panel on your Windows system
Click Programs and then Programs and Features
Right-click on Microsoft Office and choose Uninstall

Uninstall MS Office

Then run the MS Office installation setup to re-install MS Office on your system.

Solution 8: Repair Microsoft Excel (XLS/XLSX) file

In several situations, a corrupt or partially damaged Excel (XLS/XLSX) file is the cause of this error. In such a case, you can download and install Stellar Repair for Excel to repair the corrupt or damaged Excel file. By repairing the Excel file, you can resolve the Excel freezing error quickly without applying much efforts.

The steps to use the software for Excel file repair are as follows:

Download, install and launch the Excel file repair software
Browse and select the corrupt Excel file

Click ‘Repair’ to start repairing the damaged Excel file
After file repair, it provides a preview. Check your file

Then click the ‘Save File’ option in the main menu
You can either choose default location or browse a new folder location to save the repaired Excel file

After repair, open the file in Excel and continue with your work

And keep Stellar Repair for Excel installed on your system. You never know when you might need this handy tool.

You may also refer to Microsoft support for more details on Excel not responding, hangs, freezes or stops working issues.

Conclusion

Now that the methods for fixing the ‘Excel is not responding’ error are before you, try all these and see which one works for you. If the cause of this error is a damaged or corrupt Excel file, only repairing the XLS/XLSX file can resolve the issue.

For this purpose, it’s recommended to use a reliable software such as Stellar Repair for Excel as it offers an easy-to-use interface, thereby making Excel file repair process a seamless experience.

The software recovers table, chart, chart sheet, cell comment, number, text, shared formulas, image, formula, sort and filter, and other objects. It also preserves worksheet properties, layout, and cell formatting. It can repair multiple XLS/XLSX files simultaneously and fix all Excel file corruption errors.

All these features extend the software capabilities beyond just fixing the ‘Excel not responding’ error.

How to repair ‘recovered’ Excel file that won’t open

Summary: You may unable to open the Excel file after file recovery. When you try to open the file you may prompt up with error messages. This blog will discuss those errors and their solutions. Besides this, it also mentions Stellar Repair for Excel to repair and recover the severely corrupted Excel file with no data loss.

Consider a scenario: A Windows 10 user accidentally deletes a folder containing multiple Excel (XLSX) files created in Excel 2013. The worst part was all the deleted files were important, and he did not have a backup, which would help him in restoring the data. Nonetheless, he was able to recover those data using a professional data recovery software. Next, he tried opening each of the recovered Excel files one by one. In doing so, his happiness turned into disappointment. And the reason was, some of the recovered Excel files failed to open prompting error messages, of course, due to corruption. In this scenario, all he needed was to repair ‘recovered’ Excel files that did not open. Know how to fix damaged Excel files that were recovered after deletion in this blog!

Before delving into the Excel file repair methods, acquaint yourself with the probable causes leading to damaged or corrupt Excel files. Although not essential, it shall be an added advantage in helping you to prevent Excel file corruption issues in the future.

The standard Excel file(s) Corruption Causes

Power Outage – A power outage due to which a system closes suddenly or unexpectedly is a common cause of damaged Excel files.
Forced System Shutdown – Shutting down the system forcibly without closing MS Excel files is another common cause of corrupt Excel files.
PC Virus or Bug – Computer viruses or bugs may affect one or more data file if owners do not protect their PCs with powerful updated antivirus. Same is the case with malware attacks. The chances are that your computer is infected with one of these and has affected a few Excel files.
Issues with Storage Devices – Damaged or corrupted Excel files can also be the outcome of hard drive issues in the data storage systems. Logical hard drive damage is one of the most significant issues.

The damaged Excel files may prompt up with error messages. These may be:

‘Excel unable to read file’
‘Filename is not valid’
‘This file is not in a recognizable format’
‘abc.xls file cannot be accessed. The file may be read-only’
‘Excel found unreadable content in (filename)’, ‘The file is corrupt and cannot be opened’
‘Microsoft Excel has encountered a problem and needs to close’

There exist multiple methods to repair Excel files which got damaged after recovery, and are as follows: XML method,

Open Excel files with HTML
Inbuilt ‘Open and Repair’ feature/tool in Excel
Repair damaged Excel file from TMP file by using Excel AutoRecover and AutoBackup features
Recover data by configuring ‘calculation option’ as manual
Moving/copying or transferring data to a different location
Stellar Repair for Excel software

Taking Stellar software versus other methods, the former is a software solution that repairs damaged (XLS and XLSX) file quickly in major three steps: Select->Repair->Save, whereas others fall into the category of manual processes and consume both time and resources. Among the manual processes ‘Open and Repair’ method is the least time and resource consuming, which you can try quickly by following the below steps:

Open and Repair method

Click MS Excel tab and then the Open tab
Select the damaged Excel file for repairing purpose
Click the arrow present beside the Open Next, click Open and Repair tab
Click either of the following:
- Repair tab (recovers maximum data)
- Extract Data tab (Recovers values and formulas if the repair process fails in recovering the complete data.)

Note – Use ‘Extract Data’ if ‘Repair’ is not successful.

If the Manual method is not competent enough to repair recovered Excel files that don’t open then opt for a software-based solution of deploying Stellar Repair for Excel software.

Software with 100% integrity and precision

Conclusion

As an automated software, Stellar Repair for Excel is easy-to-use. You do not need technical know-how and skill set, as required to execute the manual processes. On analyzing all these methods, it is suggested to use Stellar Repair for Excel having a user-friendly GUI to repair Excel files that became damaged after recovery, or if the recovered Excel file(s) that you once deleted accidentally has become corrupt now. Above all, it is an excellent software with multiple features and advantages. Use it to address all your MS Excel issues or if any recovered Excel file is corrupt.

How to Fix the Unable to Record Macro Error in Excel?

Summary: You may encounter the “Unable to record macro” error in MS Excel when using Personal Macro Workbooks. In this post, we’ll discuss the possible causes behind this error and the ways to fix it. We’ll also mention a professional Excel repair tool that can help fix the error if it occurs due to corrupted workbook.

A personal macro workbook (Personal.xlsb file) is a hidden workbook in Excel that stores all macros in a single workbook. This allows you to automate processes while working in Excel. Sometimes, when recording macro codes in the personal macro workbook, you may get the message “Personal Macro Workbook in a startup folder must stay open for recording”. When you click on the OK button, it will show the “unable to record” error. This prevents you from recording the macros. Below, we’ll see the causes behind this error and discuss how to resolve this error.

Causes of Unable to Record Macro Error

You may be unable to record macros in Excel due to several reasons. Let’s take a look at the possible causes that can lead to this issue.

The location of personal.xlsb file is changed.
Personal.xlsb file is corrupted.
Macros are disabled.

Methods to Fix the “Unable to Record Macro” Error in Excel

Here are some possible solutions that can help you resolve the unable to record macro error in Excel.

Method 1: Check the Path of XLStart Folder

You may be unable to record macros if the path of XLStart folder is incorrect. It is a folder where the Personal.xlsb file is stored by default. Follow these steps to find out the path of this folder:

Open MS Excel. Go to File > Options.
Click Trust Center > Trust Center Settings.

In the Trust Center Settings window, click on Trusted Locations.

Verify the path of the XLSTART folder and modify it if there is an issue.
Once you are done, click on OK.

Method 2: Change Macro Security

The “Unable to record macro” error can occur if macros are disabled in the Macro Security settings. You can try changing the macro settings using the below steps:

In MS Excel, go to File > Options > Trust Center.

Under Trust Center, click on Trust Center Settings.

Select “Enable all macros” and then click OK.

Method 3: Check Add-ins for Disabled Items

If there are any items in add-ins that are disabled, they may prevent Excel from functioning properly. You can check and enable the items in MS Excel using the below steps:

Click File > Options.

In Excel Options, click on the Add-ins option.
Select Disabled Items from the Manage section and click on Go.

The Disabled Items window is displayed.
Click on the disabled item and then click Enable.
Restart Excel for the changes to take place.

Method 4: Repair your Excel File

You may fail to record macros if there is corruption in the workbook. In such a case, you can use the “Open and Repair” utility in MS Excel to repair the corrupt workbook. To use this tool, follow these steps:

Open your Excel application.
Click File > Open.
Browse to the location where the corrupted file is stored.
In the Open dialog box, choose the corrupted workbook.

From the Open dropdown list, click Open and Repair.

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

If the Microsoft utility “Open and Repair” fails to repair the corrupted Excel workbook, then try a professional Excel repair tool such as Stellar Repair for Excel. It is an advanced tool that can easily repair severely corrupted Excel (XLSX and XLS) files. It can recover all the file items, including chart sheets, cell comments, tables, macros, formulas, etc. without impacting the properties and cell format of the Excel file.

Closure

You may receive the “unable to record” error in Excel while creating or storing macros in Personal Macro Workbooks. There are several reasons that can lead to this error. You can try the methods covered in this post to resolve the error. If the error appears due to corruption in workbook, then try to repair it using the Open and Repair utility. Alternatively, you can use Stellar Repair for Excel – a professional tool that can help you repair an Excel file with problematic macros. Also, it allows recovery of all the file components with complete integrity. The tool is compatible with Excel 2021, 2019, 2016, and older versions.

How to Fix Excel Formulas Not Working Properly | Step-by-Step Guide

Summary: Excel formulas sometimes fail to function correctly and even return an error. This article explains what you might be doing wrong that prevents Excel formulas from working properly and solutions to resolve the issue. If your formulas have disappeared from the Excel spreadsheet and you are having trouble recovering them, you can use an Excel repair tool to recover the formulas.

When working with Excel formulas, situations may arise when the formula doesn’t calculate or update automatically. Or, you may receive errors by clicking on a formula.

Problems Causing the ‘Excel Formulas not Working Properly’ Issue and Solutions

Let’s check out the possible reasons that cause Excel formulas to work properly and solutions to resolve the issue.

Problem 1 – Switching Automatic to Manual Calculation Mode

Automatic and manual are the two modes of calculation in Microsoft Excel.

By default, Excel is set to automatic calculation mode. Everything is recalculated automatically when any changes are made in a worksheet in this mode. You may switch from automatic to manual mode to disable the recalculation of formulas, particularly when working with a large Excel file with too many formulas.

Excel will not calculate automatically when set to manual calculation mode. And this may make you think that the Excel formula is not working properly.

Solution – Change Calculation Mode from Manual to Automatic

To do so, perform these steps:

Click on the column with problematic formulas.
Go to the Formulas tab, click the Calculation Options drop-down, and select Automatic.

Problem 2 – Missing or Mismatched Parentheses

It’s easy to miss or incorrectly place parentheses or include extra parentheses in a complex formula. If a parenthesis is missing or mismatched and you click Enter after entering a formula, Excel displays a message window suggesting to fix the issue (refer to the screenshot below).

Clicking ‘Yes’ might help fix the issue. But Excel might not fix the parentheses properly, as it tends to add the missing parentheses at the end of a formula which won’t always be the case.

Solution – Check for Visual Cues When Typing or Editing a Formula with Parentheses

When typing a formula or editing one, Excel provides visual cues to determine if there’s an issue with the parentheses inserted in a formula. Checking for these visual cues can help you fix missing/mismatched parentheses.

Excel helps identify parenthesis pairs by highlighting them in different colors. For instance, the pair of parenthesis outside is black.
Excel does not make the opening parentheses bold. So, if you’ve inserted the last closing parentheses in a formula, you can determine if your parentheses are mismatched.
Excel helps identify parentheses pairs by highlighting and formatting them with the same color once you cross over them.

Problem 3 – Formatting Cells in an Excel Formula

When adding a number in an Excel formula, don’t add any decimal separator or special characters like $ or €. You may use a comma to separate a function’s argument in an Excel formula or use a currency sign like $ or € as part of cell references. Formatting the numbers may prevent the formula from functioning correctly.

Solution – Use Format Cells Option for Formatting

Use Format Cells instead of using a comma or currency signs for formatting a number in the formula. For instance, rather than entering a value of $10,000 in your formula, insert 10000, and click the ‘Ctrl+1’ keys together to open the Format Cells dialog box.

Problem 4 – Formatting Numbers as Text

Numbers are displayed as left-aligned in a sheet in a worksheet, and text formatted numbers are right-aligned in cells. Excel considers numbers formatted as text to be text strings. Thus, it leaves those numbers out of calculations. As a result, a formula won’t work as intended. For example, in the following screenshot, you can see that the SUM formula works correctly for normal numbers. But, when the SUM formula is applied to numbers formatted as text, the formula doesn’t return the correct value.

Sometimes, you may also see an apostrophe in the cells or green triangles in the top-left corner of all the cells when numbers in those cells are formatted as Text.

Solution – Do Not Format Numbers as Text

To fix the issue, do the following:

Select the cells with numbers stored as text, right-click on them, and click Format Cells.
From the Format Cells window, click on Number and then press OK.

Problem 5 – Double Quotes to Enclose Numbers

Avoid enclosing numbers in a formula in double-quotes, as the numbers are interpreted as a string value.

Meaning if you enter a formula like =IF(A1>B1, “1”), Excel will consider the output one as a string and not a number. So, you won’t be able to use 1’s in calculations.

Solution – Don’t Enclose Numbers in Double Quotes

Remove any double quotes around a number in your formula unless you want that number to be treated as text. For example, you can write the formula mentioned above as “1” =IF(A1>B1, 1).

Problem 6 – Extra Space at Beginning of the Formula

When entering a formula, you may end up adding an extra space before the equal (=) sign. You may also add an apostrophe (‘) in the formula at times. As a result, the calculation won’t be performed and may return an error. This usually happens when you use a formula copied from the web.

Solution – Remove Extra Space from the Formula

The fix to this issue is pretty simple. You need to look for extra space before the equal sign and remove it. Also, ensure there is an additional apostrophe added in the formula.

Other Things to Consider to Fix the ‘Excel Formulas not Working Properly’ Issue

If your Excel formula is not showing the result as intended, see this blog .
When you refer to other worksheets with spaces or any non-alphabetical character in their names, enclose the names in ‘single quotation marks’. For example, an external 5reference to cell A2 in a sheet named Data enclose the name in single quotes: ‘Data’!A1.
You may see the formula instead of the result if you have accidentally clicked the ‘Show Formulas’ option. So, click on the problematic cell, click on the Formula tab, and then click Show Formulas.
If you’re getting an error “Excel found a problem with one or more formula references in this worksheet”, find solutions to fix the error here .

Conclusion

This blog discussed some problems you might make causing an Excel formula to stop working properly. Read about these common problems and solutions to fix them. If a problem doesn’t apply in your case, move to the next one. If you cannot retrieve formulas in your Excel sheet, using an Excel file repair tool like Stellar Repair for Excel can help you restore all the formulas. It does so by repairing the Excel file (XLS/XLSX) and recovering all the components, including formulas.

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.

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.

Blog

How to fix Microsoft Excel has stopped working error? | Stellar