Excel Not Responding When Running Macros (9 Possible Solutions)

Overview

Getting the following pop-up when running macros? Large files, internal code issues, and complicated macros are just a few things that can cause this error. Here are nine ways to fix it.

Excel Not Responding When Running Macro

 


Solution 1 – Recompile Macros

Steps:

  • From the Developer tab, go to Visual Basic.

Recompile Macros to avoid Excel Not Responding When Running Macro

  • A new window will open. From that window click Tools.
  • Click Options.

Recompile Macros to avoid Excel Not Responding When Running Macro

  • The Options window will open. Click the General tab.
  • In the Compile group, tick the box on Compile On Demand.
  • Click OK.

Recompile Macros to avoid Excel Not Responding When Running Macro

  • Close the window, then add a new module.
  • Exit the Visual Basic Editor and restart the program.

Read More: How to Fix Excel Not Responding Without Closing


Solution 2 – Repair Microsoft Office

Steps:

  • Go to Settings from the Start menu.

Repair Microsoft Office to avoid Excel Not Responding When Running Macro

  • Choose Apps.

Repair Microsoft Office to avoid Excel Not Responding When Running Macro

  • Search for Microsoft Office.
  • Click on the Office icon and Modify.

Repair Microsoft Office to avoid Excel Not Responding When Running Macro

It will repair any issues with Office—including Excel.


Solution 3 – Install the Latest Windows Updates on Your Computer

By keeping Excel up-to-date, you will take advantage of upgrades and bug fixes.

Steps:

  • From the start menu, search and select Control Panel.

  • Click on System and Security in the Control Panel.

  • Choose Start maintenance.

Windows updates will be installed automatically.


Solution 4 – Clean Boot or Different Startup Options

Clean booting is a common way to free up space and clean up junk files. If there are programs that interfere with Excel, clean booting will also reset or prevent those processes from running.

Steps:

  • In the Windows Start menu, search for System Configuration.
  • As the System Configuration window spawns, go to the General tab.
  • Select Selective Startup.
  • Check all the boxes under the Selective Startup.
  • Click OK.

Clean Boot or Different Startup Options.

  • Click the Services tab.
  • At the bottom of the window, tick the box to Hide all Microsoft services.
  • Click Disable all.
  • Click OK.

  • Do the same in the Startup tab.
  • Restart your system.

Solution 5 – Disable Add-ins

Steps:

  • From the Excel start menu, click on Options.

Disable Add-ins or Remove Plug-Ins

  • In the options window, click Add-ins.
  • From the Manage drop-down menu select COM Add-ins.
  • Click Go.

  • The COM Add-ins window will open.
  • Uncheck all of the add-ins in that window.
  • Click OK.

  • Restart Excel.

Solution 6 – Start Excel in Safe Mode

Steps:

  • Press the ‘Windows+R‘ buttons on your keyboard to open the Run application.
  • Then type excel.exe/safe and press Enter or click OK.

Start Excel in Safe Mode to avoid Excel Not Responding When Running Macro

Excel will open in safe mode.


Solution 7 – Look for Third-Party Apps that Can are Causing the Issue

A third-party application may make Excel not respond properly.

  • Check any apps you added right before the problem started, or to see if any are known to conflict with any of the Office programs.
  • Make sure all your software is updated and safe.
  • Remove recent apps and add them back one at a time to see if they are causing the issue with Excel running macros properly.

Read More: Excel Not Responding When Opening File


Solution 8 – Resolve Antivirus Software Issues

  • Make sure your Antivirus software is up to date.
  • Run your software and address any adware or viruses it may find.
  • If your software integrates with Excel, remove those integrations either through your anti-virus software or in Excel’s add-ins window directly. See Solution 5 for instructions.

Solution 9 – Check If There Are Any System Constraints

As new versions of Excel are released, the requirements they need to run on your system will likely increase.

  • Visit the Excel website to see the system requirements for the latest version.
  • Verify your system meets all of the requirements.

Download Practice Workbook

Download this practice workbook below.


Related Articles


<< Go Back to Excel Not Responding | Excel Files | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Rubayed Razib Suprov
Rubayed Razib Suprov

Rubayed Razib, holding a BSC degree in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, serves as a devoted member of the ExcelDemy project. He has contributed significantly by authoring numerous articles and showcasing proficiency in VBA. Razib efficiently automates Excel challenges using VBA macros and actively participates in the ExcelDemy forum, providing valuable solutions for user interface challenges. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo