3830584 - SAP.GETVARIABLES() value does not update after prompts change in SAC Excel Add-in

After changing prompts, SAP.GETVARIABLES() continues to show last saved prompt values.

SAP Analytics Cloud, add-in for Microsoft Office

1. Use SAP.GETVARIABLES() to capture user input values from the prompt.
2. Change prompt values, and execute the workbook.
3. Observe that SAP.GETVARIABLES() still shows the previously saved prompt values.

This is current by design mentioned by the Product Manager in the enhancement request:

SAPGET formulas do not expose which data source they are linked to. As a result, triggering an automatic refresh whenever a variable changes would refresh all SAPGET* formulas in the workbook — including those that are unrelated to that data source or that do not use variables at all. This could lead to very heavy and sometimes unnecessary recalculations, which may not provide the best experience for all customers. 

To see the up-to-date variable values via SAP.GETVARIABLES(), user need to manually click "Refresh Sheet Functions" or "Refresh Selected Functions".

Refer to: Enhancement request discussion explaining SAPGET* refresh behavior

Refresh Sheet Functions, Refresh Selected Functions, SAP.GETVARIABLES(), SAPGET formulas, prompts, variables not updating, manual refresh, Excel add-in, SAC Excel, formatted sheet, raw data sheet, prompt change, variable values, not refreshing, add-in for Office, SAPGET*, formula , KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Problem

SAP Analytics Cloud all versions ; SAP Analytics Cloud, add-in for Microsoft Office all versions