#VALUE! displayed when opening Offline documents with BPC logged on

[Former Member]

SITUATION

The offline documents (by using Park N Go) open fine in Excel, though, when these documents are opened after logging on to BPC, cells display #VALUE! instead. This gives my users a hard time opening distributed reports when they are in BPC session

DATA

Macro IS enabled when opening these offline documents

We are on Office 2007 and BPC 5.1 & BPC 7.0. This particular issue occurs to both versions of BPC

Please let me know if you have a workaround, or this is a bug? Thank you!

Sincerely,

Brian Hsu

[Former Member · Accepted solution]

Hi Brian,

I can suggest you 2 things.

1. Before doing the offline distribution, go to the template, go to workbook options and select the boxes for expansion and refreshing workbook, when opened / when CV is changed. Save this template and then do the "park n go".

2. When the saved offline file is opened, this time you should not get #VALUE. If you still get the same values, then go to "park n go" and click on "set to live data and live current view".

Hope this helps.

[Former Member]

Hi,

Check the formula if you have used any, whether it contains the application name properly.

If application name is blank in formula, then it will not display values in "park-n-go' option. You need to specify the application name in formula.