SAC Microsoft Excel (Formula Error)

[former_member809799]

Hi All,

I am creating a report in excel using the SAPGETDATA formula. I'm getting a #VALUE! error on refresh but when I click into the formula itself and click out the formula displays the correct value although if I refresh the workbook again, the #VALUE! error comes back.

I have tried hard coding dimensions, getting rid of any excel formatting, excel fixes related to the number type/text, recreating the formulas from scratch, using a data source instead of a table as the SAC source but nothing seems to work...

Has anyone else encountered this error before and knows how to fix the issue?

[former_member809799 · Accepted solution]

Thanks for your input everyone.

The formula was working fine but there was a missing currency rate so the issue was actually with the underlying data.