If calculations in Excel are not working, first check Formulas > Calculation Options > Automatic, then confirm the formula is entered as a formula rather than text. Also check for a wrong cell reference, a missing equals sign, or an error value; these are among the most common reasons a result does not update or look right.
Start by identifying what is going wrong
“Not working” can mean several different things: a result stays unchanged after you edit an input, Excel displays the formula instead of its answer, a formula returns an error, or a total is different from what you expect. Identify which symptom you see before changing settings. A calculation mode issue, for example, will not fix a formula that points to the wrong cells.
Try a small check in an empty cell. With the number 2 in A1 and 3 in A2, enter =A1+A2 in A3. The expected result is 5. If Excel displays the text =A1+A2, investigate formula display or text formatting. If A3 shows 0 or another number, check the actual contents of A1 and A2 and whether the formula was entered as shown.
- Old result after an edit: check calculation mode and recalculate.
- Formula visible in the cell: check Show Formulas and the cell’s number format.
- Error such as #VALUE!: inspect the inputs and the operation being performed.
- Unexpected total: check the range, hidden assumptions, and whether numbers are stored as text.
Check Excel’s calculation mode
Excel can calculate formulas automatically or wait for a manual recalculation. If the workbook is set to manual calculation, changing a value may leave dependent formulas showing their previous results. In Excel for Microsoft 365 on Windows, select Formulas > Calculation Options > Automatic. Then press F9 to calculate open workbooks. On some keyboards, you may need to hold Fn to use the F9 key.
If results still appear stale, press Ctrl+Alt+F9 on Windows to force a full calculation of formulas. This is different from simply editing a cell: it asks Excel to recalculate formulas rather than relying only on its usual dependency tracking. On Mac, use the calculation commands on the Formulas tab; keyboard behavior can vary with the keyboard and function-key settings.
Manual mode can be useful in a large workbook where frequent recalculation slows editing, but it can also make a workbook look broken if you forget it is enabled. A workbook opened alongside others can also be affected by Excel’s shared calculation-mode behavior, so check the setting when results seem unexpectedly stale. Set the mode back to Automatic when you want edits to update results as you work.
Make sure Excel recognizes the entry as a formula
A formula normally begins with an equals sign. If the equals sign is missing, Excel treats the entry as ordinary content. A formula can also be stored as text if the cell was formatted as Text before the formula was typed, or if an apostrophe or space appears before the equals sign. In these cases, the cell may show the formula characters rather than calculate them.
First check whether Excel is displaying formulas throughout the sheet. On Windows, press Ctrl+` (the grave-accent key, often near the number 1) to toggle Show Formulas. You can also use Formulas > Show Formulas. On Mac, use the Show Formulas command on the Formulas tab if the keyboard shortcut differs on your keyboard. If every formula is visible at once, this setting is a likely cause.
If only one cell is affected, select it and inspect the Number Format on Home. If it is set to Text, change it to General, then re-enter the formula. Changing the format alone does not convert a formula already stored as text: after changing the format, press F2 and then Enter, or type the formula again. Also remove any leading apostrophe or unintended space.
Check the formula and its cell references
A formula can calculate correctly and still give the wrong answer if it refers to the wrong cells. Click the formula cell and inspect the formula in the formula bar. Confirm that each range includes the intended rows and columns, and that copied formulas have not shifted their references. For example, a relative reference such as B2 changes when copied down, while an absolute reference such as $B$2 stays fixed.
With quantities in B2:B4 equal to 2, 3, and 4, and unit prices in C2:C4 equal to 10, 12.50, and 8, enter =B2*C2 in D2. The result is 20. Copying that formula down gives 37.50 in D3 and 32 in D4. If the formula was copied but the result does not match the row, check that the quantity and price are in the expected columns and that the formula points to the same row.
With values 12, 18, and 20 in B2:B4, enter =SUM(B2:B4) in B5. It returns 50. If you intended to include a value in B5 itself, that would create a circular reference; instead, put the total outside the range being added. If you meant to total a longer list, expand the range deliberately rather than assuming Excel will include newly added rows.
Look for numbers stored as text
Imported data, copied web tables, and files created by other programs can contain digits stored as text. Text that looks like a number may not behave like a numeric value in arithmetic, sorting, or comparisons. A warning icon may offer Convert to Number; depending on the data, you can also use Data > Text to Columns and complete the conversion steps, or re-enter the values in a number-formatted cell.
Check a few suspicious cells rather than converting an entire column blindly. Look for a leading apostrophe, extra spaces, or inconsistent decimal and thousands separators. Those separators can depend on regional settings, so a value copied from another locale may not be interpreted as intended. Formatting a text value to display as Currency or Number does not necessarily change its underlying type.
Dates can have a similar problem. Excel stores recognized dates as serial numbers and displays them using a date format; text that only looks like a date may not work in date arithmetic. If subtracting two dates returns an error or an unexpected result, verify that both cells contain real Excel date values and not text strings.
Understand errors and circular references
An error message is useful evidence: it often points to a specific type of problem rather than a general calculation failure. #DIV/0! indicates division by zero or a blank denominator. #VALUE! commonly signals an incompatible value, such as text where a number is expected. #REF! means a reference is invalid, often because a referenced cell or range was deleted. #NAME? can mean Excel does not recognize text in a formula, such as a misspelled function name or an unquoted text entry.
#N/A often means a lookup did not find a match, though its meaning depends on the formula. #NUM! points to an invalid numeric argument or result, and #SPILL! can appear when a dynamic-array formula cannot place its results because cells in the output area are occupied. Clear the obstruction or inspect the formula’s intended output range rather than deleting unrelated data.
A circular reference occurs when a formula depends on its own result, directly or through a chain of other formulas. For instance, a total placed inside the range it sums can cause one. Excel may show a circular-reference warning or an unexpected result. Find the circular reference through the warning or the circular-reference commands on the Formulas tab, then change the range or formula logic. Iterative calculation is a specialized option for models designed to use repeated calculations; enabling it is not a general fix for a mistaken reference.
Check ranges, filters, and external data
When a total looks too small, verify the selected range and whether the relevant values are actually numeric. The SUM function includes numeric values in its referenced range, but it does not include cells outside that range. A filter can hide rows without changing what a standard SUM includes, so a filtered list may still have a total that counts hidden rows. If you need a total that responds to filtered-out rows, choose a suitable subtotaling approach and confirm its behavior for your workbook.
Formulas linked to another workbook may depend on a source file that has moved, been renamed, or not been updated. Check the formula bar for an external workbook reference and, where appropriate, use Data > Queries & Connections or Data > Edit Links if that command is available for the type of link. Prompts to update links should be considered carefully: update only from a source you trust. A displayed value can be a previously saved result even when the source workbook is unavailable.
For imported or connected data, recalculating worksheet formulas is not always the same as refreshing the source. Use the relevant refresh command, such as Data > Refresh All, when the issue is that a query or connection has not brought in current information. Then check whether formulas that use the refreshed data calculate as expected.
Use a careful troubleshooting sequence
Work from simple, reversible checks toward broader changes. This helps avoid fixing the wrong issue or changing workbook behavior unnecessarily.
- Save a copy if the workbook is important, then identify one affected cell and note its current result.
- Check Formulas > Calculation Options and choose Automatic if automatic updates are intended.
- Inspect the formula bar for the equals sign, spelling, parentheses, operators, and correct references.
- Check whether the cell is formatted as Text or has a leading apostrophe or space; re-enter the formula after correcting it.
- Verify that inputs are numbers or dates where required, and that the formula’s range covers the intended cells.
- Read any error value and follow the clue it provides; do not suppress an error before understanding its cause.
- Recalculate with F9, or use Ctrl+Alt+F9 on Windows if a full recalculation is needed.
Be cautious about downloading a replacement workbook or enabling macros as a first response to a calculation problem. A formula issue usually does not require code. If a file came from an unknown source, avoid enabling macros or updating external links until you have verified that the source is trustworthy.
Frequently Asked Questions
Why is Excel showing the formula instead of the answer?
Check whether Show Formulas is enabled with Formulas > Show Formulas. If only one cell is affected, change its format from Text to General and re-enter the formula. A leading apostrophe or space can also make the entry text.
Why does my Excel formula not update when I change a cell?
The workbook may be in manual calculation mode. Choose Formulas > Calculation Options > Automatic, then recalculate. If a formula uses external data, refresh or update the source as appropriate; ordinary recalculation may not refresh that data.
Why does SUM ignore some cells?
Those entries may be text rather than numbers, or they may fall outside the SUM range. Check their underlying values and the formula’s references. A standard SUM still includes numeric values in filtered or hidden rows, so filtering alone does not explain a smaller total.
Why does Excel show #VALUE! in a calculation?
One of the formula’s inputs may have a type the operation cannot use, such as text in a calculation that expects a number. Check the referenced cells for text-formatted numbers, extra characters, or unexpected spaces, then correct the input or formula.
How do I force Excel to recalculate everything?
On Windows, press Ctrl+Alt+F9 to force a full calculation. For routine recalculation, F9 is usually sufficient. On Mac, use the calculation commands on the Formulas tab if keyboard shortcuts differ.
Related
- Excel Named Range for a Table Column: How It Works
- Excel Named Range Scope Greyed Out? Causes and Fixes
- Excel Named Range Rules: Names, Scope, and Limits
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Page Breaks in Excel Won’t Go Away? How to Fix ThemIf page-break lines in Excel won’t go away, switch to View > Normal to leave Page Break Preview,…
- Excel Won’t Let You Merge Cells in a Table? Here’s WhyExcel does not allow merged cells inside an Excel table. If you need a merged heading, put it…
- Why Is INDEX MATCH Not Working? Common Excel FixesINDEX MATCH usually fails because MATCH is using the wrong match type, the lookup and return ranges do…
- Excel VLOOKUP Not Working? Common Causes and FixesExcel VLOOKUP usually fails because the lookup value does not exactly match the first column of the selected…
- Pasting Formula in Excel Not Working? Fixes That HelpIf pasting a formula in Excel is not working, first check whether the destination cell is formatted as…
- Excel Filter Not Grouping Dates by Year? How to FixIf Excel’s filter menu is listing individual dates instead of grouping them by year, first check that the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.