Excel Formulas not updated if scheduled by Launchpad

[Former Member]

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

[former_member193885]

Hey Jesper,

Do you have AO 2.1 SPS 2?  See note below.

http://service.sap.com/sap/support/notes/2188635

Deepu

[torsten_wirth]

Hi Deepu,

I have checked the note "Formula SAPGetVariable VALUEASTEXT does not return text" but how is this connected to the above topic?

[Former Member]

Hi Jesper,

Have you check the following note

https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/smp_custmsg/note_index.htm?note_number=...

It lists that excel formulas are not precalculated

[Former Member]

Hello Michael,

thanks for your help but I can not open your link. Is it a SAP note? If yes, could you tell me the number instead?

Best Regards

Jesper

[Former Member]

This is Michael's note: http://service.sap.com/sap/support/notes/2134836

BR, Martin