3783562 - Improve performance of SAP.GETDATA and SAP.SETDATA formulas using the Optimize Data Retrieval setting in SAC Add-in

Performance is slow when many SAP.GETDATA or SAP.SETDATA formulas are used in SAC Add-in.

SAP Analytics Cloud, add-in for Microsoft Office

In Workbook Preferences, set Optimize Data Retrieval to Enable optimized data retrieval.

• Define the workbook design
• SAP.GETDATA
• SAP.SETDATA

slowness, slow, bad performance, long time, latency, lag, freeze, recalculation, throughput, bottleneck, scalability, bulk formulas, mass formulas, workbook slowdown, writeback, configuration, tuning, SETDATA, GETDATA, new feature, 2026 QRC 3 , KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Product Enhancement