SAC addin formulas not refreshing

[ioannis33]

Dear all,

We are facing an issue with SAC addin. We can connect to the tenant but the "Refresh Functions" does not work anymore, while we can Refresh tables without issues. All SAC custom formulas are changed to the _xldudf_SAP_GETDATA format and do not work even if we switch them back to SAP.GETDATA

This started since the 13th-14th of December more or less when the last update of SAC addin took place.

Did anyone else notice anything similar or has any idea what could be the root-cause for this.

Thank you,

Ioannis

[ismaelheinen · Accepted solution]

Hello Ioannis,

This is an issue with Microsoft Excel Add-in Analysis ToolPak.

From SAP's side, we have KBA below:
3418085 - The SAC Excel Add-in formulas in locally saved Excel workbooks present a preffix with FUNCRES.XLAM'!_xldudf_

Regards,
Ismael Heinen