Forum Discussion

Devin_Jones's avatar
Devin_Jones
Icon for Microsoft rankMicrosoft
Feb 27, 2023

Automatic recalculation optimization in Excel makes your active workbook more performant

The introduction of the single document interface (SDI) in Excel 2013 made it possible for users to open and run multiple, unrelated workbooks in a single instance of Excel. Additionally, when using the Automatic Calculation mode, any of these workbooks has the potential to trigger a recalculation of all open workbooks, which increases the risk of slowing down the performance of the active workbook.

 

Minimize the risk of slowness and increase performance by limiting the recalculation process to the active workbook and any of its interdependent workbooks.

 

NOTE: Workbooks with real-time streaming functionality (such as Realtime Data), as well as recalculation initiated either programmatically or manually by pressing the F9 key or selecting Formulas > Calculate Now are exceptions to this optimization. 

 

 

 

 

Head over to the blog post to learn more and check if it's available for your current build!

 

Best,

Devin


Microsoft 365 Insider Social Community Manager

 

Become a Microsoft 365 Insider and gain exclusive access to new features while helping to shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android

No RepliesBe the first to reply

Resources