Check Profiling statistics in Analysis for Office to improve performance
With AO 2.3 updated versions, tracking performance of a workbook for every step that has been performed is made much easier. Statistics can be traced with respect to workbook as well as Client.
1. Go to settings in order to enable profiling statistics.
File –> Analysis –> Settings –> Support
2. Refresh the workbook to track statistics. Click on messages.
3. Click on the below options to view profiling statistics.
This helps in tracking steps accurately and in detail to analyze the delayed performance of a workbook.