Many Excel tutorials give the same advice for speeding up spreadsheets: avoid variable functions. While this can help, software settings often have a bigger impact on performance. If your spreadsheets are lagging—even on a high-end computer—you may need to change how Excel handles calculations. These two hidden settings can make large workbooks feel faster.
Stop Excel from recalculating after each edit
Take back control
It’s something we’ve all experienced at some point: you open an important workbook, click a cell to update a single value, hit Enter, and the program freezes temporarily. The cursor turns into a rotating blue circle, and because you’re only changing one data point, you’ll have to wait while Excel processes a large workbook.
This frustrating delay is often caused by Excel’s default behavior. Configured for automatic calculation out of the box. As soon as the value changes, the program recalculates the affected cells and their dependencies.
If your table is simple with only a few dozen rows, you get instant feedback and that feels great. But as your workbook becomes a large file filled with thousands of complex formulas, certain formula types increase this problem significantly. Large search operations are repeated over thousands of rows volatile functions Recalculate when you make any changes to the workbook, such as OFFSET, INDIRECT, NOW, TODAY, and RAND, which can increase the overall computational load on large files. This creates incredibly long dependency chains, meaning that the more complex your file becomes, the more background work Excel forces to do after each edit.
But large searches and variable functions can be really useful, so it’s not always easy to just remove them. Instead, to control the recalculation while you work. Here it is:
-
open Formulas badge.
-
expand Calculation Options drop down menu.
-
Change the setting here Automatic for Manual.
After you toggle this switch, Excel no longer automatically recalculates after each edit. Instead, it waits until you manually start the process. You can type, paste, delete lines, and rearrange blocks of data without waiting for the software—or worse, worrying about it crashing completely. Excel feels noticeably faster because recalculation no longer interrupts your editing.
Just when you are ready to see the updated results of your work press F9 to force a recalculation of the entire workbook or Shift+F9 to calculate only the active sheet. Alternatively, click Calculate now or Calculation sheet in the year Formulas badge.
Manual calculation is not ideal for every workflow. If you rely on seeing live results while building formulas or checking data, Auto mode is a better choice. Manual mode works best in heavy editing sessions where responsiveness is more important than instant updates.
Verify that Excel is using all CPU cores
Maximize your hardware
Modern versions of Excel are designed to handle heavy math workloads using multi-threaded computing. Instead of forcing your computer to process a large chain of formulas sequentially using only one execution path, multithreading allows Excel to divide your data into independent workloads and solve them in multiple workloads simultaneously. CPU cores.
However, there are a few situations where these settings can change without you noticing:
- Excel has reached its resource limit: In some cases, Excel may temporarily reduce or disable multi-threaded processing when system resources are under heavy pressure.
- The latest Office patches and updates: Some Microsoft updates can sometimes fix advanced performance settings.
- Third-party add-ons or VBA macros: Certain supplements or old macros can adjust computing settings during startup, especially in enterprise environments.
- Random changes: It is also possible to disable multiple threads when troubleshooting or manually changing the configuration.
Multi-threaded computing becomes more important when workbooks contain a large number of formulas spread over a significant dataset. Financial models, dashboards, forecasting sheets, and exported database tables often involve calculations that can be efficiently split between processor cores. Small spreadsheets usually don’t show dramatic gains, so these settings become more important when the complexity of the workbook starts to push Excel beyond light use.
To fix this bottleneck, you need to check your configuration settings:
-
click File.
-
choose Options.
-
open Advanced badge.
-
scroll down through the settings until you see Formulas division.
-
There, sure Enable multi-threaded computing is checked and make sure the switch is set Use all the processors on this computer.
Enabling this setting allows Excel to divide calculation tasks into smaller tasks and spread them across your CPU cores.
Standard computations on large datasets often scale efficiently across multiple processors, but some operations still depend on the speed of a single thread. In rare cases, when combined with older macros or certain background plugins, perennials can behave unpredictably. Checking your settings simply ensures that Excel uses its full power when possible.
- OS
-
Windows, macOS, iPhone, iPad, Android
- Brand
-
Microsoft
- Price
-
$100/year
- Developer(s)
-
Microsoft
- Free trial
-
1 month
Microsoft 365 includes access to Office apps like Word, Excel, and PowerPoint on up to five devices, 1 TB of OneDrive storage, and more. includes
Restore your table speed
Even large notebooks shouldn’t feel painfully slow. Switching to calculation mode during editing sessions and confirming that Excel can take full advantage of your hardware can make your spreadsheets more responsive. For many large workbooks, these two settings can eliminate most of the slowdown, however minor Excel workflow optimizations—such as using the Name Box for navigation and customizing the Quick Access Toolbar—can improve your efficiency when working with large tables.
