Excel Performance Problems

How to Fix Excel Freezing When Calculation Is Set to Manual

Adam Davis Oct 14, 2026 869 views

Question details

Users experience unexpected unresponsiveness and freezing in Microsoft Excel when handling heavy workbooks, despite having disabled automatic calculation.

Why Excel Freezes When Calculation Is Set to Manual and How to Fix It

Product: Microsoft Excel
Device & OS: not provided
Scenario: Opening or working with large, complex workbooks containing external links, volatile formulas, or files stored on cloud drives like Teams or SharePoint.
Observed behavior: Excel becomes unresponsive, lags, or completely freezes during intensive operations other than formula recalculation.

Before you start

Check your Task Manager (Ctrl+Shift+Esc on Windows) to verify that Excel is not currently running a hidden background query or data model update before you attempt to modify the workbook structure.

Solution 1Recommended

Optimize Workbook Structure and Storage Location

Reduce workbook complexity by managing file locations, clearing excess formatting, and dividing large datasets.

Manual calculation only stops formulas from recalculating. It does not prevent Excel from struggling with massive formatting metadata, remote server latency, or heavy external links.

Test a Local Copy

If your file is stored in Microsoft Teams or SharePoint, download a copy directly to your local hard drive and open it. This rules out network latency and server synchronization issues as the cause of the freeze.

Clear Excess Formatting

Select unused rows and columns below and to the right of your actual data. Go to the Home tab, click 'Clear' in the Editing group, and select 'Clear All' to remove unnecessary formatting metadata.

Divide the Workbook

If the workbook contains massive amounts of raw data alongside complex dashboards, split the raw data into a separate workbook. Use smaller, purpose-specific files instead of an all-in-one approach.

Optimize Workbook Structure and Storage Location

Best Practice: Following Microsoft's performance guidance by keeping raw data and reporting dashboards in separate, interconnected files significantly reduces calculation bottlenecks.

Solution 2

Use Power Query and Reduce Volatile Formulas

Replace performance-heavy functions and cross-sheet lookups with more efficient data retrieval methods.

Free Microsoft Office alternative

Try WPS Office for Lightweight and Fast Spreadsheet Management

If Microsoft Excel continues to freeze when handling large workbooks or complex data, consider trying WPS Office. It provides a highly optimized, lightweight spreadsheet experience that handles heavy data efficiently without the steep system requirements.

1. Download and Install: Visit the official WPS website to download the free, lightweight WPS Office suite.
2. Open Your Excel File: Launch WPS Spreadsheet and open your .xlsx file directly to experience faster loading and processing speeds.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv) and formulas.Lightweight installation ensures faster load times for large and complex workbooks.Free to use with a familiar, tabbed interface for a seamless transition.Stable performance even on older computers and operating systems.

microsoft office alternative - wps office

Frequently Asked Questions

Does manual calculation stop all background processes in Excel?

No, setting calculation to manual only pauses formula recalculations. Excel still performs other intensive operations like querying external links, rendering complex formatting, updating pivot caches, and syncing with cloud storage.

Why does my Excel file freeze when opening from Microsoft Teams?

Opening files directly from Teams or SharePoint introduces network latency and synchronization delays. Excel constantly communicates with the server to manage co-authoring and file locks, which can cause freezing on large files.

What are volatile formulas in Excel?

Volatile formulas, such as TODAY(), OFFSET(), and INDIRECT(), recalculate constantly during certain workbook events, even if their specific precedent cells haven't changed. Excessive use of these formulas causes severe performance issues in large files.

Can clearing unnecessary formatting improve spreadsheet performance?

Yes. Applying formatting (like colors, borders, or custom number formats) to entire columns or rows creates immense amounts of excess metadata. Clearing formats from unused cells significantly reduces the file size and prevents the application from lagging.

Excel & Data Problems