Skip to Content
Feb 05, 2019 at 01:05 PM

Issue with offline mode formula

173 Views Last edit Feb 06, 2019 at 05:24 AM 2 rev

Hi all,

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?




offline-ok.png (13.6 kB)
offline-not-ok.png (34.6 kB)