Excel Performance Problems

How to Fix Excel Workbook Stuck on Calculating with Multiple Threads

Bushra Parveen Oct 15, 2026 870 views

Question details

The user needs to resolve an issue where an Excel workbook gets stuck on the 'Calculating - 8 Threads' status after making changes to the file.

How to Fix Excel Workbook Stuck on Calculating with Multiple Threads

Product: Microsoft Excel, OneDrive
Device & OS: not provided
Scenario: Editing a 2.81 MB Excel workbook saved in personal OneDrive.
Observed behavior: The workbook remains stuck on 'Calculating' with multiple threads. Standard fixes like disabling add-ins, removing conditional formatting, or repairing Office Online do not resolve the issue.

Before you start

Before making structural changes, ensure you have saved a backup copy of your 2.81 MB workbook to your local drive to prevent any accidental data loss.

Solution 1Recommended

Isolate the File and Test on a Local Drive

Move the file from OneDrive to your local storage to determine if network synchronization is causing the calculation delay.

Network latency or OneDrive syncing conflicts can sometimes cause Excel to hang during auto-calculation. Testing locally helps rule out cloud storage issues.

Close Microsoft Excel

Ensure that Excel is completely closed and not running in the background.

Locate in OneDrive

Open File Explorer, navigate to your personal OneDrive folder, and locate the affected workbook.

Copy to Local Storage

Right-click the file, select 'Copy', and then paste it into a strictly local directory, such as your Desktop or Documents folder.

Test the File

Open the local copy in Excel and make a minor data change to see if the 'Calculating' issue persists.

Isolate the File and Test on a Local Drive

Testing Across Devices: If the problem continues on your local drive, try transferring the file to a different computer to determine if the issue is device-specific.

Solution 2

Identify and Optimize Volatile Functions

Reduce large calculation chains and volatile functions that can severely degrade spreadsheet performance.

Solution 3

Switch to Manual Calculation Mode

Temporarily pause automatic recalculation so you can safely edit the workbook without freezing.

Free Microsoft Office alternative

Experience Faster Calculations with WPS Office

If Microsoft Excel continues to struggle with multi-threaded calculations on your complex workbooks, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for handling large datasets and complex formulas without the frustrating software hangs.

1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite for your operating system.
2. Install the Software: Follow the on-screen instructions to quickly install the application.
3. Open Your Workbook: Launch WPS Spreadsheet, click 'Open', and select your Excel file to enjoy seamless, stutter-free calculations.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Optimized calculation engine for handling complex formulas smoothly.Lightweight installation that consumes fewer system resources.Familiar user interface requiring zero learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel get stuck on 'Calculating 8 Threads'?

This usually happens when a workbook contains highly complex calculation chains, volatile functions (like OFFSET or INDIRECT), or broken external links that force Excel to recalculate the entire sheet repeatedly, exhausting available processor threads.

Does the file size affect multi-threaded calculations in Excel?

Yes, but formula complexity matters more than file size. A small 2 MB file with thousands of array formulas or volatile functions can take significantly longer to calculate than a 50 MB file containing only simple data entries.

How do I manually change the number of calculation threads in Excel?

Go to File > Options > Advanced, scroll down to the Formulas section, and under 'Enable multi-threaded calculation', you can select 'Manual' to set a specific number of calculation threads instead of using all available processors.

How can I check my exact Excel version for troubleshooting?

Open Excel, click on 'File' in the top-left corner, and select 'Account'. On the right side under Product Information, you will see your Office version, build number, and update channel.

Excel & Data Problems