How to Fix Excel Closing Slowly When Add-Ins Are Enabled
Question details
Users experience a significant delay, often 30 to 40 seconds, when closing Excel if one or more add-ins are enabled.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Closing the last active Excel workbook while third-party or organizational COM add-ins are running.
- Observed behavior
- Excel takes an unusually long time to shut down completely, whereas the application closes instantly when all add-ins are disabled or in Safe Mode.
Before troubleshooting, save all active workbooks and make a list of the specific add-ins your organization requires to function.
Identify and Disable Problematic COM Add-ins
Isolate the specific plugin causing the shutdown delay by disabling add-ins one by one, such as the Google Drive for Office COM add-in.
Third-party COM add-ins are a frequent cause of performance degradation in Excel. By systematically disabling them, you can pinpoint which specific add-in is extending the shutdown time.
Launch Microsoft Excel, go to the 'File' tab, select 'Options' at the bottom, and click on 'Add-ins' in the left pane.
At the bottom of the Options window, select 'COM Add-ins' from the Manage dropdown list and click 'Go'.
Uncheck all add-ins in the list and click 'OK'. Restart Excel, then enable the add-ins one by one, closing the application each time to identify the culprit.
Unhide and Close Background Workbooks
Hidden workbooks loading in the background can interfere with add-ins and slow down the Excel shutdown sequence.
Perform a Microsoft Office Repair
Repairing the Microsoft Office installation can fix corrupted core files that cause performance issues when add-ins are active.
Switch to WPS Office for a Faster, Lightweight Spreadsheet Experience
If Microsoft Excel continues to close slowly due to heavy add-in bloat and configuration issues, consider switching to WPS Office. It is a highly compatible, free, and lightweight alternative designed to open and close instantly without performance lags.
- 1. Download and Install: Visit the official WPS website to download and install WPS Office for free on your device.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheet and directly open your existing Excel workbooks without formatting loss.
- 3. Experience Fast Performance: Edit, save, and close your documents instantly, free from the heavy lag caused by traditional Office add-ins.
Frequently Asked Questions
Why does Excel close instantly in Safe Mode but slowly normally?
Safe Mode opens Excel without any add-ins, customizations, or hidden workbooks loaded. If the application closes instantly in Safe Mode, it strongly confirms that an active add-in or startup file is causing the shutdown delay.
Can antivirus software cause Excel to close slowly?
Yes, many antivirus programs have security integrations or add-ins that scan Excel files upon closing. Disabling the antivirus add-in within Excel temporarily can help determine if it is responsible for the lag.
What if my organization requires the add-in causing the delay?
If a mandatory add-in causes the issue, try updating the add-in to the latest version, installing any pending Windows or Office updates, and consulting your IT department to review organizational group policies that might conflict with the plugin.
