Forum Discussion
Devin_Jones
Microsoft
Feb 27, 2023Automatic 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