Excel formulas are not updating: distinguish calculation mode from text

Identify what the cell actually shows

A useful small comparison in an unused area is to enter 2 in one cell and reference it with a simple multiplication in the next. Then change the input to 3. Use this only as a diagnostic example, not as proof that the workbook's business calculations are correct.

Choose the matching symptom

If results stay old

Before changing calculation settings, save your work and note the existing mode. Microsoft states that changes in desktop Excel affect all open workbooks. A large workbook may also take time to recalculate.

On Windows, open File > Options > Formulas and inspect Workbook Calculation. Automatic recalculates dependent formulas as relevant values change. For a manual comparison, Formulas > Calculate Now recalculates open worksheets. Microsoft's calculation reference explains the distinction.

Repeat your small input change. If that result now updates but the original formula does not, look at the original dependencies rather than assuming the mode fixed everything. Changing calculation mode is not a substitute for refreshing an external data source.

If you see formulas instead of results

Use Formulas > Show Formulas to switch the worksheet between formulas and results, as described in Microsoft's display guide. This changes the view; it does not rewrite the expressions.

If neighboring formulas show results but one cell displays its literal entry, inspect that cell separately. Microsoft recommends changing a text-formatted formula cell to General, then pressing F2, followed by Enter, to re-enter it. Confirm that the entry begins with =. See Microsoft's formula troubleshooting.

Limit that change to the affected formula cells. Columns containing account codes or other identifiers may intentionally be text; changing them can create a different problem. Keep the untouched copy until you have checked the result.

Check the repaired calculation, not just its appearance

Compare a few known inputs with independently expected outputs. Inspect one formula that depends on the repaired cell too. A number appearing is evidence that something calculated, not evidence that it used the intended source cells.

If the cell displays an error, follow that specific error's documentation instead of repeatedly toggling calculation. For persistent problems, use the support/community links in Microsoft's formula guide with your Excel version and an anonymized sample. Do not upload client financial or personal data to a public forum.

We reviewed the documentation but did not run Excel calculations. If the underlying issue is text dates or identifiers, see date values that do not sort correctly or preserving leading zeros.