Sum and calculation · Short guide

Why are Excel formulas not updated?

Braxorn · Last updated 2026-11-22 · English

If you change an entry but the result remains the same, the calculation mode may be set to manual. However, if the cell contains a constant value or text instead of a formula, a similar appearance will be created.

What can you do?

  1. Verify that there is indeed a formula starting with = in the result cell.
  2. Examine the calculation options in the Formulas section; For normal use, consider Automatic.
  3. Change a controlled input and recalculate. If the relevant result does not change, examine the referenced cells. Let

A small example

A2=5 and =A2*2 in B2. When you set A2 to 7, B2 should be 14. If it does not change, the calculation setting or formula link should be investigated.

What to watch for

Changing the calculation setting in desktop Excel may also affect other open workbooks. Automatic calculation may take time for large files.

Check the result

After saving and reopening the file, check that it responds correctly to the same input.

Examples are synthetic. Formulas use English function names and comma separators; names or separators may differ with your Excel language and regional settings. Menus and features vary by version.

Microsoft source (English)

Microsoft source (English)

Review your own workbook

You can start reviewing your Excel file in Braxorn. Check which controls are supported and review incomplete checks alongside the report scope.

Review your file