SAP Analysis for Excel - How to save function values when saving a file .xlsx?

[former_member606228]

I have report in SAP Analysis for Excel with function =SAPListOfEffectiveFilters("DS_1") in cell. If I save the file on disk and open it the cell value = "#N/A". How to save function (=SAPListOfEffectiveFilters("DS_1")) values when saving a file .xlsx?

[former_member606228]

I see. Thanks. VBA.

[KonradZaleski]

To display this value you need either to be connected to the system (i.e. by clicking Refresh and logging into the system) or you need to unselect the property Remove Data Before Saving