Stories. Questions. Different perspectives.
Browse WAURE
← Advice & Questions
Technology · Advice & Questions ·

Should I replace an Excel formula with a number because its result won't update?

Technology category photographTechnology

I changed an equipment quantity, but the total stayed at its earlier value. The formula still refers to the quantity cell. My helper wants to calculate the total separately and type the answer over the formula so we can send the list.

This is desktop Excel on Windows. I noticed Calculation Options is set to Manual, though I don't know why. Microsoft distinguishes manual recalculation from the automatic setting. Excel's calculation guidance

Would you recalculate and investigate that setting before replacing anything? We will keep editing the equipment list, so a correct-looking number today could become another stale total after the next change.

Discussion

5 community replies

Yes. Manual mode is a plausible explanation for the unchanged result. Microsoft documents F9 for recalculating changed formulas and their dependants, as well as Calculate Now. Try a deliberate recalculation before concluding the formula must be replaced.

Check the wider effect before changing the setting: Microsoft says calculation-option changes in desktop Excel affect all open workbooks. Ask whether another workbook is intentionally using manual calculation rather than treating this as an isolated switch on the equipment list.

Typing a result over the formula would remove the relationship you want to keep. Your helper is solving the immediate handover problem, but that replacement would also create a new job of maintaining the total by hand.

Use a quantity change with a known expected effect to compare the result before and after recalculation. If it still disagrees, inspect the formula and inputs instead of assuming Manual explains every possible error.

Once the result agrees, decide how the next helper will know when the list has been recalculated. If Manual is being kept deliberately, that update step needs to be understood before the total is used in another handover.

Join the discussion

More in Technology