Calculation Issues

How to Fix Excel Formulas Not Recalculating Automatically

Maira Mehtab Sep 27, 2026 870 views

Question details

The user needs to fix Excel formulas that are not updating or recalculating automatically, often due to manual calculation settings or workbook resource limits.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Working with large workbooks containing complex formulas, volatile functions, or extensive data.
Observed behavior: Formulas do not update automatically. Switching the calculation setting to Automatic may trigger an out-of-resources error, and stale-value strikethrough formatting might persistently appear.

Before you start

Before changing calculation settings on a very large file, save a copy of your workbook. Switching to automatic calculation in resource-heavy files may temporarily freeze your application.

Solution 1Recommended

Set Workbook Calculation to Automatic

Change the calculation option from Manual to Automatic to ensure formulas update immediately when data changes.

Excel allows you to control when formulas calculate. If this is set to Manual, your formulas will not show updated results until you force them to.

Open the Formulas Tab

Navigate to the top ribbon and click on the 'Formulas' tab.

Access Calculation Options

Locate the 'Calculation' group and click on 'Calculation Options'.

Select Automatic

Choose 'Automatic' from the drop-down menu. Your formulas should now recalculate immediately.

Keyboard Shortcut: If you prefer to keep calculation on Manual, you can press F9 at any time to manually calculate all open workbooks.

Solution 2

Reduce Workbook Complexity

Prevent out-of-resources errors by optimizing formulas and reducing the workbook's computational load.

Solution 3

Address Stale-Value Formatting Bugs

Handle persistent stale-value formatting by reporting the issue directly to Microsoft.

Efficient Spreadsheet Solution

Automatically Recalculate Complex Formulas Smoothly in WPS Office

WPS Office Spreadsheet provides a lightweight and highly optimized environment for managing heavy workbooks. You can easily enable automatic calculation and handle large datasets without experiencing the severe resource-heavy stuttering common in other programs.

1. Open your workbook in WPS Spreadsheet: Launch WPS Office and open the complex spreadsheet file you need to work on.
2. Navigate to the Formulas tab: Click on the 'Formulas' tab located in the top ribbon menu.
3. Select Calculate Options: Click on the 'Calculate Options' button in the toolbar.
4. Enable Auto Calculation: Check the 'Auto Calculation' option from the drop-down menu so your formulas update instantly without freezing.

Highly compatible with Microsoft Excel (.xlsx) files and advanced formulas.Lightweight software architecture that handles large data ranges smoothly.Completely free core spreadsheet functions and formula calculation.Familiar user interface with immediate access to calculation settings.

microsoft office alternative - wps office

Frequently Asked Questions

Why do my formulas only update when I double-click on them or press F2?

Your workbook calculation option is likely set to Manual. In this mode, Excel only updates a formula when you actively edit the cell or force a manual recalculation. You can fix this by changing the Calculation Options to Automatic in the Formulas tab.

What does an 'Out of Resources' error mean when calculating formulas?

This error signifies that your workbook contains too many complex formulas, massive data ranges, or volatile functions for your system's available memory and processing power to calculate simultaneously.

How do I identify volatile functions causing performance issues?

Look for functions like INDIRECT, OFFSET, TODAY, NOW, RAND, and RANDBETWEEN. These functions recalculate with every single change made anywhere in the workbook, heavily increasing processor load and slowing down performance.

What is stale-value strikethrough formatting?

In newer versions like Microsoft 365 web, cells containing outdated formula results (when manual calculation is on) are sometimes formatted with a strikethrough. This warns you that the values have not been recalculated yet to reflect recent data changes.

Excel & Data Problems