Excel Performance Problems

How to Fix Excel Freezing with Large Linked Workbooks

Maira Mehtab Sep 22, 2026 869 views

Question details

Excel periodically freezes and becomes unresponsive when multiple large, interconnected workbooks are open simultaneously.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Working with two large workbooks (approximately 17 MB and 63 MB) containing interconnecting links, with manual calculation enabled.
Observed behavior: Excel freezes every 30 to 45 minutes while the files are open, interrupting workflow.

Before you start

Before modifying your large files, create secure backup copies of both workbooks so you can test simplifications without risking permanent data loss.

Solution 1Recommended

Simplify and Optimize Workbook Content

Reduce the structural complexity and size of your workbooks by eliminating memory-heavy elements that cause Excel to stall.

Large workbooks often contain hidden bloat, such as high-resolution images, excessive formatting, and complex volatile formulas that recalculate constantly in the background.

Remove or compress images

Navigate through your worksheets and delete any unnecessary pictures. For remaining images, click on them, go to the Picture Format tab, and select Compress Pictures to reduce their footprint.

Convert pivot tables to values

If you have pivot tables that no longer require active filtering or updating, copy the entire table and paste it back as 'Values' to stop background cache processing.

Eliminate volatile formulas

Identify formulas like OFFSET, INDIRECT, TODAY, and NOW. These force recalculations across linked files. Replace them with static data or alternative index-based formulas where possible.

Clear unused formula-heavy ranges

Highlight any blank rows or columns extending past your actual dataset, go to the Home tab, click Clear, and choose Clear All to remove invisible formatting or residual formulas.

Solution 2

Isolate Files and Test External Links

Determine if the external link calculation between the two large files is the root cause of the freezing.

Solution 3

Update System and Request Deep Support

Ensure your environment has sufficient resources and is running the latest software versions.

Free Microsoft Office alternative

Use WPS Office for Smoother Performance on Large Spreadsheets

If Microsoft Excel continues to freeze when handling large, heavily linked workbooks, consider switching to WPS Office. Its optimized memory management makes it a highly capable, lightweight, and free alternative for managing complex spreadsheets without the constant stuttering.

1. Download and install: Visit the official WPS website, download the free version of WPS Office, and run the quick installer.
2. Open your large files: Launch WPS Spreadsheet and open your 17 MB and 63 MB files directly to experience faster load times and stable performance.
3. Manage links seamlessly: Go to the Data tab in WPS to effortlessly manage your external workbook links using familiar tools.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv)Lightweight architecture ensures smoother performance on large filesHandles complex external links and massive datasets efficientlyFamiliar user interface requires no learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel freeze even when set to manual calculation?

Even with manual calculation enabled, Excel still performs background checks, memory allocation for display rendering, and autosave operations. If the files contain excessive formatting, large images, or thousands of volatile formulas, these background processes can cause memory spikes that freeze the application.

How do I find and break external links in my Excel workbook?

Go to the Data tab on the ribbon and click on Edit Links in the Queries & Connections group. A dialog box will appear listing all external sources. Select the link you want to remove and click Break Link. This converts the linked data into static values.

What are volatile formulas and how do they impact performance?

Volatile formulas—such as NOW(), TODAY(), OFFSET(), and INDIRECT()—recalculate every time any change is made anywhere in the workbook, regardless of whether their dependent cells changed. In large workbooks, this creates massive, continuous calculation chains that drain system resources.

Is a 63 MB Excel file considered too large?

While Excel can theoretically handle files up to 2 GB in 64-bit versions, a 63 MB file is practically considered very large, especially if the size is driven by complex formulas, pivot caches, and cross-workbook links rather than raw text data. Files of this size often experience performance degradation.

Excel & Data Problems