If Excel for Microsoft 365 is not updating formula results, first choose Formulas > Calculation Options > Automatic. If results still do not change, check whether the formula is stored as text, whether its referenced cells actually changed, and whether a workbook or data connection is still calculating.
How Excel automatic calculation works
Excel normally recalculates formulas when a value they depend on changes. For example, if a total adds several cells and you edit one of them, Excel updates the total without requiring you to run a command. The setting that controls this is the calculation mode: Automatic, Automatic Except for Data Tables, or Manual.
In Microsoft 365 for Windows, find it on the Formulas tab under Calculation Options. Automatic is the usual choice for everyday spreadsheets. Automatic Except for Data Tables updates ordinary formulas automatically but does not recalculate what-if analysis data tables each time a value changes. Manual postpones calculation until you request it. A workbook can therefore appear to contain stale answers even though its formulas are intact.
Calculation mode is an Excel application setting that can affect other open workbooks, not just the sheet currently on screen. If one workbook is in Manual mode, changing to Automatic can also cause other open workbooks to recalculate. In a large or complex file, that may take time, so allow Excel to finish before deciding that nothing happened.
Switch calculation back to Automatic
- Open the workbook in the Excel desktop app and select the Formulas tab.
- Select Calculation Options, then choose Automatic.
- Wait for the status bar to show that calculation is complete, if Excel displays a calculation message.
- Change a value that a formula uses, or force a calculation as described below, to check whether the result updates.
If Automatic is already selected, choose it again only if the menu indicates another mode; then investigate the formula and its inputs. To calculate now in Windows, press F9. Depending on your keyboard, you may need to hold Fn as well. F9 recalculates open workbooks. Shift+F9 recalculates the active worksheet. For a deeper recalculation of all formulas, Ctrl+Alt+F9 forces a full calculation; Ctrl+Alt+Shift+F9 also rebuilds the dependency information Excel uses to determine what needs recalculating. These commands can be slow in a large file.
On a Mac, check the Formulas tab and its Calculation Options control, then use the available Calculate Now or Calculate Sheet command if needed. Function-key behavior can depend on the Mac’s keyboard settings, so the ribbon command is a useful alternative. In Excel for the web, check the Formulas tab for Calculation Options; available controls can vary with the current web experience. If a command is unavailable, open the file in the desktop app.
Check whether the formula is a real formula
A cell can look like it contains a formula while Excel treats its contents as ordinary text. This commonly happens when a cell was formatted as Text before the formula was entered, or when an apostrophe was placed before the equals sign. In either case, changing calculation mode will not make the cell calculate.
- Select the cell and look at the formula bar. If the formula appears as literal text, inspect the cell format and check for a leading apostrophe.
- On the Home tab, change the number format to General, then re-enter the formula. A practical method is to select the cell, press F2, and press Enter.
- If many cells are affected, select the range, set it to General, and re-enter the affected formulas. Merely changing the format may not convert existing text into formulas.
Also look for Show Formulas mode, which displays formulas in cells instead of their calculated results. On Windows, press Ctrl+` (the grave-accent key, often near the number 1) to toggle it, or use Formulas > Show Formulas. The Mac keyboard shortcut can differ by keyboard layout; use the ribbon command if the shortcut does not work. This display mode does not mean calculation has stopped—it changes what the worksheet shows.
Test a small example and inspect references
A simple test can separate a calculation problem from a formula-specific issue. With 10 in A1 and 5 in B1, enter =A1+B1 in C1. The result should be 15. Change A1 to 12; C1 should become 17. If this test works but the original result does not, focus on that original formula’s inputs, references, or data source rather than Excel’s general calculation setting.
Look closely at which cells the formula references. A formula may be working correctly but point to the wrong row, an old range, or a different sheet. For example, a total that refers to B2:B10 will not include a new value entered in B11. Check the formula bar, click referenced cells where practical, and confirm the range includes the new data. When a formula uses absolute references such as $A$1, copying it will keep pointing to that fixed cell; this is intentional in some layouts but can be surprising in others.
Another common misunderstanding is expecting a formula to respond to a change that is not among its dependencies. If a formula refers to a value in one cell, editing a separate cell that it never references should not change its result. Trace the calculation from its inputs, and verify that the input cells contain the expected numbers or dates rather than text that only looks numeric.
Handle external links, queries, and volatile results
Not every value shown in a workbook is recalculated from an ordinary cell formula. A result may depend on another workbook, a Power Query refresh, a linked data type, or a connection to an external source. Recalculation can update formulas based on the data currently stored in the file, but it does not necessarily fetch fresh source data. If the formula result is unchanged after F9, determine whether the underlying source itself needs to be refreshed.
For a query or connection, use the workbook’s refresh controls on the Data tab, such as Refresh All when appropriate, and wait for the refresh to complete. External-link prompts, sign-in requirements, unavailable files, or network restrictions can prevent current source values from loading. A workbook may still display its last saved values, which can look like a calculation failure. Check for refresh messages and confirm that the source file or service is accessible before changing formulas.
Functions that depend on time or recalculation, such as NOW and RAND, can also appear to behave differently from a direct input-based formula. They update when Excel recalculates, but they do not necessarily change continuously every second. Pressing F9 can trigger a new value. If a function is meant to show a date or time, confirm that the cell’s number format is appropriate; a valid result displayed as a serial number may be mistaken for a failed calculation.
When calculation is slow or seems stuck
Automatic mode can be correct while a workbook takes a long time to update. Large ranges, many dependent formulas, complex array calculations, external links, and repeated calculations across multiple sheets can all increase the workload. Excel may display Calculating or a percentage in the status bar. Wait for that process to finish, especially before closing the workbook or making repeated edits that trigger more calculations.
To identify a performance issue, try a copy of the workbook and calculate one sheet at a time with Shift+F9. If one sheet is notably slower, inspect its formulas and external connections. Avoid replacing formulas or changing calculation settings across the original file until you understand what depends on them. Manual mode can be a temporary choice for a very large model during extensive edits, but it is easy to forget that results are then stale. Restore Automatic before relying on the results or sharing the workbook.
Calculation settings do not correct errors such as #VALUE!, #REF!, or #NAME?. Those messages indicate a problem with the formula, its references, or its inputs, not simply that automatic calculation is off. Read the error and inspect the cells it depends on. For example, a deleted referenced cell can produce #REF! even after a full recalculation; the formula’s reference must be repaired.
Save, reopen, and compare Excel versions
If the setting appears correct but the workbook still behaves unexpectedly, save a copy, close the workbook, and reopen it in the Excel desktop app. This can help distinguish a temporary calculation delay from an issue tied to the current workbook session. Check that the file is not opened in a viewer or compatibility environment that limits editing, and confirm that you are looking at the current saved copy rather than an older duplicate.
Excel for the web and Excel for Mac share many formula behaviors with Windows, but ribbon placement, keyboard shortcuts, and available commands can vary. On the web, browser connectivity and external-data support may also affect whether source data refreshes. If a particular file behaves differently across versions, compare the calculation mode, formula results, and refresh status in the desktop app. Do not assume that refreshing a browser page is the same as recalculating formulas or refreshing every external connection.
Frequently Asked Questions
Why does Excel only calculate when I press F9?
If pressing F9 updates the result, the workbook is likely in Manual calculation mode. Choose Formulas > Calculation Options > Automatic. If Automatic is already selected, check whether the formula is stored as text or depends on a source that needs a separate refresh.
Why does one Excel workbook calculate automatically but another does not?
Calculation mode can affect other open workbooks in the same Excel application, and workbook contents can also differ. Check Calculation Options while the affected workbook is open, then inspect whether its formulas, data sources, or cell formats differ from the working file.
Will changing a cell from Text to General fix a formula?
It may be necessary, but it may not be sufficient. After changing the format, re-enter the formula—select the cell, press F2, then Enter. Excel needs to interpret the contents as a formula rather than retain the text already stored in the cell.
Does F9 refresh Power Query or external data?
Not necessarily. F9 recalculates formulas using the data currently available in the workbook. Use the relevant refresh command on the Data tab to request updated query or connection data, and resolve any sign-in, source-file, or network issue that prevents the refresh.
Why do I see formulas instead of their answers?
Show Formulas may be enabled, or the cells may be formatted as text. Turn off Formulas > Show Formulas first. If only certain cells still show formula text, set those cells to General and re-enter the formulas.
Related
- Merge Columns in Excel with Power Query
- Meal Planning Excel Sheet: Build a Weekly Planner
- Meal Planning Template Excel: Free Options and Setup
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel Sort Expand Selection Not Working? Try These FixesIf Excel’s Expand the selection option is not working, cancel the sort, select the entire data range—including every…
- Excel #NAME? Error: What It Means and How to Fix ItThe Excel #NAME? error means Excel cannot recognize something written in a formula, such as a function name,…
- COUNTIFS Not Working With Multiple Criteria? Fix ItIf COUNTIFS is not working with multiple criteria, check that every criteria range is the same size, that…
- Why Am I Getting a #REF! Error in Excel?You are getting a #REF! error because an Excel formula contains a reference that is no longer valid,…
- Excel Drag Down Formula Not Updating? Fix Common CausesIf an Excel formula does not update when you drag it down, first check that Excel is set…
- Excel Divide by Zero Error: Causes and Practical FixesTo fix a #DIV/0! error in Excel, check that the formula’s divisor is not zero or blank, then…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.