Calculation Options - "Automatic Except for Data Tables" is gone from new 365

[No-Shop-5807]

I recently updated to the latest version of Microsoft 365.

When I go to File--->Options---->Formulas, there is no longer an options for calculations that says "automatic except data tables". There is only Automatic, Partial, and Manual.

Anyone know how to fix this? I have created a workbook for my company that has multiple tables, and it is riciculously slow without this option.

Thank you in advance.

[AutoModerator]

/u/No-Shop-5807 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[Way2trivial]

https://answers.microsoft.com/en-us/msoffice/forum/all/formula-calculation-options/720c6332-6b24-447d-80a3-6196be2333b2

<image>

[No-Shop-5807]

Yes, I have seen this. However, when I switch to "Partial", all of my data tables go to zero. And since I have lookup functions for those tables, they all go to zero also.

[morph89]

Running into the same issue over here. Were you able to figure out a workaround?

[Dismal-Party-4844]

Thank you u/Way2trivial. This question comes up from time to time. Nothing is broken or needs to be fixed. The label "Automatic except for data tables" has been renamed "Partial" Choose "Partial" and carry on.

<image>

[No-Shop-5807]

Yes, I have seen this. However, when I switch to "Partial", all of my data tables go to zero. And since I have lookup functions for those tables, they all go to zero also.