How to Fix Excel Not Responding Without Closing

Most Excel users have experienced the problem of Microsoft Excel Not responding, freezing, getting stuck or crashing. You will find below the steps to fix Microsoft Excel not responding issue.

Fix Microsoft Excel Not Responding Error in Windows 10

Microsoft Excel Not Responding

Introduced way back in 1985, Microsoft Excel has grown into one of the most popular, powerful and indispensable computer programs, used by workplaces all over the world.

However, Microsoft Excel can sometimes freeze up, stop working or even crash while working on large or complex spreadsheets.

On such frustrating occasions, you may see an error message reading "Excel is not responding", or "Excel has stopped working."

We are providing below a number of methods that can fix the issue of Microsoft Excel not responding on your computer.

1. Repair Microsoft Office

The problem of Microsoft Excel not responding might be due damaged or corrupted program files. This can be fixed by using the Repair option as available on your Windows computer.

1. Right-click on the Start button and click on Run.

Open Run Command in Windows

2. In the Run Command Window, type appwiz.cpl and click on OK.

Run appwiz Command in Windows

3. On the next screen, right-click on Microsoft Office and click on the Repair option.

Repair Microsoft Office Program

Note: If the Repair option is not available, right-click on Change > select Repair in the pop-up and click on Continue.

Wait for the repair program to repair the Microsoft Office program.

2. Change Default Printer

Microsoft Excel can become unresponsive if it is unable to communicate with the default printer on your computer.

This can be fixed by temporarily switching the default printer on your computer to Microsoft XPS Document Writer.

1. Open Settings > click on Printers & Scanners.

Printers and Scanners On Windows Settings

2. On the next screen, click on Printers & Scanners in the left pane. In the right-pane, click on Microsoft XPS Document Writer and click on Manage.

Manage Microsoft XPS Document Writer

3. On the next screen, click on Set as Default option.

Set Microsoft XPS Document Writer As Default Printer

After setting Microsoft XPS Document Writer as the default printer, open Microsoft Excel and see if it is now working properly on your computer.

3. Run Excel in Safe Mode

This method can help if the problem is being caused by a Plug-in or an Add-on program.

1. Right-click on Start button and click on Run.

Open Run Command in Windows

Note: You can also press Windows + R key to open the Run Command window

2. On the Run command window, type excel.exe /safe and click on OK to start Microsoft Excel in Safe Mode.

Run excel.exe /safe command in Windows 10

3. Now try opening the particular Non responsive Excel File again.

If this method helps in fixing the problem, you can follow the next method as provided below to disable the Add-in programs on your computer.

4. Disable Add-Ins & Plug-ins

Follow the steps below to disable Plug-ins and Add-in programs.

1. Right-click on Start button and click on Run.

Open Run Command in Windows

2. In the Run Command Window, type excel.exe /safe and click on OK to start Microsoft Excel in Safe Mode on your computer.

Run excel.exe /safe command in Windows 10

3. Once you are in Microsoft Excel, click on the File tab in top menu bar > scroll down and click on Options.

Open Excel Options

Note: In older versions of Excel, click on File Icon > Excel Options button

Excel Options button

4. On the next screen, click on theAdd-ins in the left pane. In the right-pane, select Excel Add-ins and  click on the Go… button.

Excel Options Screen

5. On the Add-Ins screen, uncheck the little box next to the active Add-Ins and click on OK to save.

Disable Excel Add-Ins on Windows 10 Computer

After disabling Add-Ins, restart Microsoft Excel and see if the problem of Microsoft Excel Not Responding is now fixed.

In case the problem is fixed, try to isolate the particular Add-in that is causing problems by disabling the Add-Ins one by one.

Particular Microsoft Excel File Not Responding

In this case, the problem appears to be confined to a particular Spreadsheet and the Excel Program itself is working fine.

In many cases, this problem can be fixed by clearing conditional Formatting from the spreadsheet.

1. Open the Excel File that is getting stuck on your computer.

2. On you are in the file, click on Home > Conditional Formatting > Clear Rules > Clear Rules From Entire Sheet.

Clear Conditional Formatting From Microsoft Excel Worksheet

This will clear Conditional Formatting from this particular sheet.

3. Now, select other Tabs (in case you have any) from the bottom of the sheet and clear Conditional Formatting in those sheets as well.

Change Sheets in Excel

4. Save this Excel File with a New Name, so that the original Excel File will also be available on your computer. You will be able to make use of the original File, in case required.

If this fixes the problem, it confirms that the file is getting stuck due to conditional Formatting.

The next step would be to narrow down the problem to a particular sheet or section of the File and apply corrections as required

  • How to Create Pivot Tables in Excel
  • Excel File is Locked For Editing By Another User

How to Fix Excel Not Responding Without Closing

Source: https://www.techbout.com/microsoft-excel-not-responding-29777/

0 Response to "How to Fix Excel Not Responding Without Closing"

Post a Comment

Iklan Atas Artikel

Iklan Tengah Artikel 1

Iklan Tengah Artikel 2

Iklan Bawah Artikel