EPMExecuteAPI - SaveAndRefreshWorksheetData doesnt work

[Former Member]

Hi,

I have input template (.XLSX) with formula =EPMExecuteAPI("SaveAndRefreshWorksheetData","Save").When I double click, it simply shows the formula and nothing happens. Does the input form need to be a XLXM or XLTM for EPMExecuteAPI to work. ?

In sheet options "Use as Data Input" is already checked.

I tried to save the file as XLSM with same results.

If i use the save data button on the EPM ribbon, data is saved successfully.

In developer tab, FPMXLClient is enabled in references.

If i connect to a different model in the same environment the formula works on that model.

Any ideas for this strange behavior.

BPC 10.0 SP22 NW

Thanks,

Bobby

[Former Member]

Hi

There is no need to enabled FPMXLClient in developer tab for run function, EPM Execute API. It worked without activate  FMPXLClinet from developer tab. There is no need to save file XLXM or XLTM the function also worked in XLSX file,regarding your problem you may be try to save the data in node label member.Check the context and input schedule member if is there any node label member are there.

Khokan

[former_member186338]

Looks like the issue is with some specific model... Note sure it will help but check that doubleclick is enabled in user options...  Also instead of epmexecuteapi it may be better (more visible) to use an Excel button with VBA macro attached.

Vadim

[Former Member]

Double click is already enabled in user options. Can you think of any model specific settings that would cause this issue.

Thanks,

Bobby

[Former Member]

When the formula "EPMExecuteAPI("SaveAndRefreshWorksheetData","SEND")

is put into a blank worksheet the content of the cell is changed to FALSE. What does that mean.?