Automatic recalculation optimization in Excel makes your active workbook more performant

Microsoft

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. 

 

Caulculate-Now-in-XL-2048x199.png

 

 

 

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

0 Replies