formula = EPMRetrieveData #REF to VALUE\possiple?

[former_member381444]

Experts, good afternoon! When you reopen the report with the formula = EPMRetrieveData, instead of the value in the cell, #REF is displayed, and in the calculated cells we get the VAL. As a result, it is impossible to analyze indicators. Is it possible to save in the cell the value which was at the time the book was closed?

[former_member381444]

Undoubtedly bad, but business requires just such an implementation. Is it possible to save the value in a cell, other than rewriting in the cell a formula "=EpmRetrieveData" to value using a macro?

[former_member186338]

"but business requires just such an implementation" - sorry, but business will never ask you to implement EPMRetrieveData.

It's your job to provide a solution without EPMRetrieveData!

[former_member186338]

It's a bad practice in general to use EPMRetrieveData!

Use normal EPM reports.