Workbooks now surface Diagnostics that give insights into your workbook’s performance and dependencies. This feature is for advanced users to identify expensive calculations in their workbook that may be impacting performance. Access Diagnostics via Help in the header.
Within the Diagnostics panel, the Calculation tab surfaces any elements that took more than 100 ms to process in your last workbook action.
Click on any element to navigate directly to that location in the workbook.
The Dependencies tab lets you select a cell, table, or range, see all upstream and downstream dependencies, and easily navigate to them in the workbook.
You can use these insights to further optimize your workbook’s performance. Learn more about using Diagnostics here.