Should I replace an Excel formula with a number because its result won't update?
TechnologyI 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.