SAP Knowledge Base Article - Preview

3664819 - SAC Add-in keeps running or takes extended time to refresh a large workbook

Symptom

  • SAC add-in reports keep running and sometimes do not finish.
  • In some cases, the refresh finish after an extended time where the status remains in "Processing".
  • The issue happens with the SAC add-in reports with a huge data volume.
  • During the refresh, it shows Calculating (XX threads) in the Excel status bar.
  • Further analyses reveals that most of the time is consumed by the rendering process to display the rather large table in Excel itself. Very little time, on the other hand, is spent retrieving data from the backend.


Read more...

Environment

  • SAP Analytics Cloud, add-in for Microsoft Office
  • SAP Analytics Cloud

Product

SAP Analytics Cloud, add-in for Microsoft Office 1.0

Keywords

excel add-in, sap analytics cloud, sac add-in, report processing, refresh delay, excel rendering, large table performance, system requirements, hardware optimization, processing status, refreshing, calculating threads, many cells , KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.