3627940 - analysis for office report refresh performance degradation

• A report launched with Analysis for Office takes longer and longer to refresh each time it is refreshed.

1. Launch a report with Analysis for Office.
2. Refresh the report multiple times.
3. Observe the increasing time taken for each refresh.

• Excel gets slower when AO uses the Excel API to render the crosstabs.
• The workbook contains many shape objects (356 shapes).
• The property "Formats" is disabled for both crosstabs, causing Excel to take a long time to do the formatting.

1. Enable the "Formats" property for both crosstabs in the workbook.
2. Delete all shape objects from all sheets in the workbook.
3. Test the workbook to verify improved refresh times:

• Performance troubleshooting guide for Analysis for Office
• Profiling traces instructions
• AO performance help
• Case Details
• Teams Telephone conference ID: 27891806

performance, analysis for office, report refresh, excel addin, crosstabs, shapes, formats, rendering, refresh times, troubleshooting, excel api, performance degradation , KBA , BI-RA-AO-XLA , Excel Addin , Problem