Excel Formulas not updated if scheduled by Launchpad
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.