Start a new topic

EPM Add-In: EPMSaveData not recognizing sheet identifier

Symptom:

EPMSaveData is putting value at wrong location. Data is replicated in two worksheets.


Reproducing the Issue:

- Create a report in EPM Add-in.
- Use EPMSaveData function.
- Fill the first parameter of the function with a target cell to another sheet.


Cause:

This behavior is by design.


The function EPMSaveData only support the first parameter to be in the same worksheet, this is mandatory. 

So it's not possible to post the result in a different worksheet.


Resolution:

User can put this data to another sheet directly through simple Excel functions like '='.

Login or Signup to post a comment