Excel Performance Problems

How to Fix Excel Workbook Taking 30 Minutes to Close

John Wilson Sep 28, 2026 869 views

Question details

A specific Excel workbook takes up to 30 minutes to close, causing the application to freeze and become unresponsive.

How to Fix an Excel Workbook That Takes 30 Minutes to Close

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to close a heavy or problematic workbook after working on it.
Observed behavior: Excel freezes or takes an excessive amount of time (up to 30 minutes) to close the file, even when running in Safe Mode with add-ins, external links, and automatic calculation disabled.

Before you start

Before making any changes, create a backup copy of your Excel file and save it to a different local folder to prevent data loss during the troubleshooting process.

Solution 1Recommended

Locate and Remove Hidden or Corrupted Objects

Invisible shapes or corrupted objects often bloat the file and cause severe unresponsiveness when saving and closing.

Over time, copying and pasting data from web sources or other applications can bring over hundreds of invisible objects into Excel. These hidden elements force the application to use excessive memory during the closing process.

Open the Go To Special Menu

Press Ctrl + G on your keyboard to open the Go To dialog box, then click the Special button at the bottom left.

Select All Objects

Choose the Objects radio button from the list and click OK. This will select and highlight all graphical objects on the active worksheet, including those with zero size.

Delete Hidden Objects

If unexpected objects are highlighted, press the Delete key on your keyboard to remove them. Repeat this process for all sheets in the workbook.

Save and Test

Save the file using File > Save As with a slightly different name, then try closing the workbook to see if the speed has improved.

Locate and Remove Hidden or Corrupted Objects

File Size Reduction: Removing hidden objects often drastically reduces the file size and resolves closing delays immediately.

Solution 2

Disable Automatic Calculation Before Closing

Switching the calculation mode to manual can bypass delays caused by Excel attempting to recalculate heavy formulas as the application closes.

Solution 3

Recreate the Workbook in a New File

If the file is deeply corrupted, transferring the raw data to a completely new workbook is the most reliable fix.

Free Microsoft Office alternative

Open and Edit Heavy Spreadsheets Smoothly with WPS Office

If Microsoft Excel struggles to close your files without freezing, WPS Spreadsheet is a highly efficient, free alternative that uses fewer system resources while offering seamless compatibility.

1. Download WPS Office: Visit the official WPS website and download the free installer for your operating system.
2. Open Your Workbook: Launch WPS Spreadsheet, click Open, and select your slow-closing Excel file.
3. Edit and Save Seamlessly: Experience much faster load and close times without altering your original formatting or data integrity.

High compatibility with Microsoft Excel (.xlsx, .xls, .csv) file formatsLightweight architecture that prevents lagging and freezing on heavy data filesFamiliar tabbed user interface requiring no new learning curveFree to use with comprehensive data analysis and spreadsheet capabilities

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel only freeze when closing, not while editing?

Excel performs memory cleanup, state saving, and sometimes final background recalculations upon closing. If the file contains thousands of hidden objects, fragmented memory paths, or complex volatile formulas, this cleanup process can stall the application entirely.

Does Safe Mode fix Excel closing delays?

Safe Mode disables add-ins and toolbar customizations. If your file still takes 30 minutes to close in Safe Mode, it proves the issue is related to the specific workbook's internal data or corruption, rather than external plugins.

How can I tell if my specific Excel file is corrupted?

Common signs of a corrupted Excel file include sudden crashes, unresponsiveness during basic tasks like saving or closing, unexpected file bloat (very large file size with minimal data), and formatting applying itself arbitrarily to blank cells.

Will repairing the Microsoft Office installation fix this slow workbook?

Repairing Office usually fixes application-wide issues. Because this problem happens with one specific workbook, recreating the file or cleaning up its hidden objects is much more likely to resolve the delay than repairing the entire Office software suite.

Excel & Data Problems