Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Excel Formulas not updated if scheduled by Launchpad

Hi experts,

I hope you can help me solving following problem:

I created a boa workbook and saved it on the platform. It contains a dynamic header. This header contains formula "sapgetvariable()". Everything works perfekt if I just open the workbook using boa. But if I send the workbook from launchpad by mail I get an "#NV"-error.

My second solution was to put the infoobject (related to variable) into columns. After this I used standard excel formula CONCATENATE() on this cell. Now I have the problem that by sending by email again excel formula has not been updated. I have to go into the cell by F2 and then enter to get the right data.

Please note that I fill the mentioned infoobject while scheduling in launchpad!


I am using BOA version 2.1.

Best regards

Jesper

Not what you were looking for? View more on this topic or Ask a question