3616250 - Long Refresh Time When Changing Filters in SAC Addin Workbook

When changing the value of a filter in a SAC Addin Workbook, the refresh process takes approximately 30 seconds to complete.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

.

SAP Analytics Cloud 1.0.

1. Open an Excel Workbook.
2. Sign-In to our SAC tenant.
3. Click on the pencil icon for the dimension for which you want to change the value.
4. Remove selected value.
5. Select another value.
6. Click OK.
7. Wait until the loading process is done and the new value is shown.
8. It takes around 30 seconds to finish.

One possible cause is the presence of numerous styles in the workbook. Some issues in Excel cause styles to duplicate multiple times.

Please clean up the Excel workbook. 

KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Problem