Excel Not Calculating Formulas Automatically: How to Fix It

Hào Võ · Updated Nov 19, 2026

Excel không tự động tính toán công thức: Nguyên nhân và cách khắc phục

Excel not calculating formulas automatically is a common and frustrating problem that slows your work. This article explains the causes and how to fix it quickly.

How to fix Excel not calculating formulas automatically: the most common cause is that calculation is set to Manual. Fix: go to Formulas > Calculation Options > Automatic (or File > Options > Formulas > Workbook Calculation = Automatic). Other fixes: (1) press F9 to recalculate now, or Ctrl+Alt+F9 to recalculate everything; (2) check the cell is not formatted as Text (the formula shows as text): change it to General and re-enter the formula; (3) turn off Show Formulas if it is on; (4) check for circular references; (5) make sure the formula starts with =.

Why does Excel stop calculating formulas automatically?

  • Manual calculation mode: in manual mode, formulas do not update when data changes.
  • Formula errors: syntax errors or incorrect references stop formulas calculating correctly.
  • Calculation settings: some advanced settings affect automatic calculation.
  • Software or file problems: Excel bugs or a damaged file can interrupt calculation.

Check your calculation mode first

How to check the calculation mode

  1. Open Excel and go to the Formulas tab.
  2. Look at Calculation Options.
  3. Check whether Automatic is selected; if not, select it.

How to turn on automatic calculation in Options

  1. Click File.
  2. Choose Options.
  3. In Excel Options, choose Formulas.
  4. Under Calculation options, select Automatic.
  5. Click OK.

Note: the calculation mode is taken from the first workbook you open in a session, so a manual-mode file can switch other workbooks to manual too.

Are formula errors stopping Excel from calculating?

Fixing #VALUE!, #DIV/0! and #NAME?

  • #VALUE!: check that the referenced cells contain valid data of the right type.
  • #DIV/0!: you are dividing by zero or an empty cell; check the divisors in your formula.
  • #NAME?: usually a misspelt function or range name; check the formula syntax.

Check and fix formula syntax

  • Check commas or semicolons (depending on regional settings), brackets and special characters.
  • Use Evaluate Formula on the Formulas tab to step through the formula.

Advanced settings that affect calculation

Disable add-ins that may conflict

  • Go to File > Options.
  • Choose Add-ins and disable unnecessary add-ins.

Optimise calculation for large files

  • Reduce the number of complex or volatile formulas.
  • Use PivotTables instead of heavy calculation formulas where possible.

Other solutions

Update Excel

Make sure you are using the latest version; check under File > Account > Update Options.

Repair Office

If nothing else works, repair Office: Control Panel > Programs and Features > Microsoft Office > Change > Quick Repair (or Online Repair).

When should you use manual calculation?

  • In very large workbooks, manual mode can save processing time while you edit.
  • When you want to make many changes before seeing the results (press F9 to calculate when ready).

We hope this helps you fix Excel formulas that do not calculate automatically. For Microsoft 365 support for your business, contact IT Systems at hotline 028.3995.03.59 or contact@itsystems.com.vn.

Need a technician to check your computer on site?

IT Systems repairs desktops and laptops on site in Ho Chi Minh City, offers remote support within 30 minutes and quotes for your approval before any repair.

On-site computer repair · Call +84 28 3995 0359

Request adviceChat on ZaloCall hotline