Excel Performance Problems

How to Fix Slow Excel Calculation and Improve Formula Performance

Bushra Parveen Oct 19, 2026 868 views

Question details

The user is experiencing severe performance delays and freezing when performing basic operations in a workbook heavily populated with lookup formulas.

How to Fix Slow Excel Calculation and Improve Formula Performance

Product: Excel
Device & OS: not provided
Scenario: Performing simple copy-and-paste tasks in a multi-sheet workbook containing thousands of rows and extensive VLOOKUP and MATCH formulas.
Observed behavior: Excel takes about one minute to process simple tasks, continuously displaying a 'Calculating: 8 threads' message.

Before you start

Save your current workbook and consider creating a backup copy before making structural changes to your formulas or modifying large data ranges.

Solution 1Recommended

Optimize Formulas and Data References

Reduce the calculation load on your processor by replacing inefficient functions and limiting the scope of your referenced cell ranges.

Heavy formulas searching through massive cell ranges are the primary cause of multithreading bottlenecks. Restricting references to exact data sizes prevents Excel from calculating millions of empty cells.

Remove full-column references

Instead of referencing an entire column like VLOOKUP(A1, Sheet1!A:Z, 2, FALSE), change the range to exactly match your data, such as Sheet1!A1:Z1000.

Upgrade to efficient lookup functions

If you are using modern spreadsheet software, replace VLOOKUP with XLOOKUP or INDEX/MATCH combinations, which process faster over large arrays.

Eliminate duplicated calculations

If multiple formulas look up the same exact match, perform the MATCH calculation once in a helper column and reference that helper cell in subsequent formulas.

Avoid Volatile Functions: Functions like OFFSET, INDIRECT, TODAY, and NOW recalculate every time any change is made anywhere in the workbook. Replace them with non-volatile alternatives whenever possible to drastically improve speed.

Solution 2

Enable Manual Calculation Mode

Temporarily pause automatic background calculations while editing your workbook to prevent constant freezing.

Solution 3

Use Excel Tables for Dynamic Ranges

Convert your raw data into structured Tables to automatically adjust referenced ranges without resorting to slow full-column references.

Efficient Spreadsheet Software

Experience Fast Calculations with WPS Spreadsheet

WPS Spreadsheet is highly optimized for performance, easily handling large datasets and complex formulas without freezing. Enjoy a seamless experience working with massive workbooks.

1. Open your workbook: Launch WPS Spreadsheet and open your heavy .xlsx file.
2. Toggle Manual Calculation: Go to the Formulas tab, click Calculation Options, and switch to Manual mode to edit without interruptions.
3. Optimize Functions: Use WPS Spreadsheet's built-in advanced formula support to switch heavy VLOOKUPs to faster XLOOKUPs.
4. Calculate instantly: Press F9 anytime to trigger a highly optimized background calculation across your massive data ranges.

Handles heavy multithreaded calculations and large datasets smoothly100% format compatibility with Microsoft Excel (.xlsx, .xls)Supports modern, fast lookup functions like XLOOKUP and INDEX/MATCHFree, lightweight, and consumes fewer system resources

Frequently Asked Questions

Why does my spreadsheet say 'Calculating: 8 threads'?

This message indicates that the software is using multithreaded processing, splitting the calculation workload across your computer's 8 processor cores. If it hangs on this message, it means your workbook contains an overwhelming number of complex formulas or excessively large reference ranges.

Is XLOOKUP faster than VLOOKUP for large datasets?

Yes. XLOOKUP is generally more efficient because it only processes the specific lookup array and return array, whereas VLOOKUP must hold the entire table array in memory, including unneeded columns between the lookup and return values.

How do I force a complete recalculation of everything in the workbook?

If you suspect some cells aren't updating properly, you can press Ctrl+Alt+F9. This forces the application to rebuild the entire dependency tree and completely recalculate all formulas in all open workbooks, regardless of whether they have changed.

Why does formatting affect calculation speed?

Excessive formatting, especially conditional formatting applied to entire columns (like A:A instead of A1:A100), forces the spreadsheet engine to evaluate rules against over a million cells, heavily degrading performance whenever data is pasted or updated.

Excel & Data Problems