Skip to Content
avatar image
Former Member

SapSetData returns #VALUE (problem with using reference cells in formula) - AFO 2.4

Hi, Experts!

We're trying to use sapsetdata function to save data that previously were calculated in excel.

Input Query:

SapSetData returns normal value (cell D2) when we hardcode technical keys of info objects and their value. See the figure below. This doesn’t suit for us, because we’ve got a dynamic input schedule and the number of rows (and as a result combination of elements of the info-objects) may vary.

SapSetData returns #value error (cell C2) when we are using reference cells as parameters for info objects technical keys and their values in formula:

Does anybody have guesses why the second variant not working?

P.S. we were using this «how to guide» for our solution - https://blogs.sap.com/2016/12/06/using-the-formula-sapsetdata-for-offline-planning-with-sap-businessobjects-analysis-for-office-2.3-onwards/

first.png (11.6 kB)
first.png (12.1 kB)
second.png (56.1 kB)
third.png (24.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers