Excel - file date now large, so automatic calculation not working correctly

shane cundy 20 Reputation points
2026-03-11T04:53:37.13+00:00

Is there a way to get auto calc to always work or calc when I want? Alternativily which button is used to activate manual calculation? Cannot find in help as file locks out, thanks

Microsoft 365 and Office | Excel | For home | Windows
0 comments
Answer accepted by question author
DaveM121 929K Reputation points Independent Advisor
2026-03-11T06:11:39.3066667+00:00

On the formulas menu at the top of Excel, in the Calculation section, is the Calculation Options drop-down menu set to Automatic, if so, it is very unusual if your workbook is not calculating automatically.

For manual calculation, in that Calculation section, there should be a 'Calculate Now' button or you can press F9 or Shift + F9 to perform a manual calculation on the sheet or full workbook.

Was this answer helpful?

0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest

  1. AI answer

    2026-03-11T04:53:52.3733333+00:00

    To control when Excel recalculates, change the workbook’s calculation mode.

    Turn automatic calculation back on (so formulas always recalc):

    1. Select File > Options.
    2. Select the Formulas category.
    3. In Calculation options under Workbook Calculation, select Automatic.
      • This recalculates all dependent formulas every time a value, formula, or name changes.

    Use manual calculation (so it only recalculates when requested):

    1. Select File > Options.
    2. Select the Formulas category.
    3. In Calculation options under Workbook Calculation, select Manual.
      • When set to Manual, Excel only recalculates when requested.

    Buttons/commands to recalculate in Manual mode:

    • To recalculate all open workbooks: on the Formulas tab, in the Calculation group, select Calculate Now (or press F9).
    • To recalculate only the active sheet: on the Formulas tab, in the Calculation group, select Calculate Sheet.

    Note: Changing these options affects all open workbooks.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.