Share via

Iterative Calculations in Excel for Office 365

Anonymous
2019-09-25T01:56:49+00:00

How can I use iterative calculations while working with circular references in Excel for Office 365?  I cannot find a way to enable this function.  Earlier versions of Excel had a box in the Formulas -> Calculation Options section that could be checked to enable iterative calculations an indicate the maximum iterations and maximum change, but this does not seem to be available any longer.  Any suggestions would be helpful.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2019-09-26T02:01:28+00:00

Hi E.Haus,

To enable and control iterative calculation in Excel Office 365 in windows version as I mention above please, open Excel file click File> Options > Formulas, and select the Enable iterative calculationcheck box under the Calculation options. you can follow my below screenshot steps.

Let us know if you need additional assistance.

Best Regards,

Waqas Muhammad

Was this answer helpful?

5 people found this answer helpful.
0 comments

5 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-09-25T21:12:54+00:00

    Version Office 365. There appears to no longer an option to "enable iterative calculation" as shown in my screen shot below.https://learn-attachment.microsoft.com/api/attachments/1b3bf819-671b-4e39-bcc4-8134929c6929?platform=QnA"https://learn-attachment.microsoft.com/api/attachments/1b3bf819-671b-4e39-bcc4-8134929c6929?platform=QnA" rel="ugc nofollow">

    Was this answer helpful?

    6 people found this answer helpful.
    0 comments
  2. Anonymous
    2020-01-24T17:33:22+00:00

    Is there a way to keep the iterative calculation box checked so that I don't have to check the box for each file I work in?

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments
  3. Anonymous
    2019-11-15T01:04:36+00:00

    When I select File and then Options it takes me back to the worksheet and I can't enable iterative calculations

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  4. Anonymous
    2019-09-25T05:39:34+00:00

    Hi James,

    Thanks for posting query in our forum and we are Glad to help you.

    According to your description, you can use Iterative calculation function in Excel Office 365 for business via go to File > option> Formula> click Enable iterative calculation.

    You mentioned the function is missing, could you share your Office version number and subscription type in File >Accounts, and share a related screenshot like my picture above?

    Let us know if you need additional assistance.

    Best Regards,

    Waqas Muhammad

    Was this answer helpful?

    0 comments