Share via

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
  1. DaveM121 851.1K 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.

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Q&A Assist
    2026-03-11T04:53:52.3733333+00:00
    AI generated content. This question contains an answer created with AI from Q&A Assist. Learn more

    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:

    0 comments

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.