I have an Excel file with a number of sheets that each contain one or more EPM reports. As such the file works fine, but the offline mode causes issues. When I select the offline mode most sheets look like this:
the formula has been extended with a =WENN() condition which is what I would expect. And as I am working in a German Excel =WENN() is the correct syntax.
On some of the sheets however, I get this
on these sheets BPC / the EPM add-in has user =IF instead of =WENN. Excel is looking for the german version, so does not understand the english version.
Has anyone seen this behaviour before?