Skip to Content
0

Offline mode blowwing up Excel formulas, Why?

Feb 20, 2017 at 05:51 PM

149

avatar image
Sheryl Bourlier

We use Office 2010 right now (moving to Office 2016) Using BPC v10 SP25

Worksheets with simple filtering macros were working with Offline Mode until recently in BPC. We have made no changes in BPC recently. If the worksheet is filtered and we select Offline Mode, some but not all of the formulas seem to blow up and give errors (EPMRetreiveData, EPMMemberDesc, etc.) ranging from #N/A, to just pulling in incorrect descriptions, pulling a description into a cell that was bringing back data before; etc.

EPM Add-In for Excel
offline
Answers Answers and Comments
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Sort by:
Best Answer
avatar image
Sheryl Bourlier Answered Apr 07, 2017 at 05:32 PM
0

Final answer, system bug that won't let you move the drop down further. Works when you shift to EPMPane or move down divider so drop down box is all in same section

Show 1 Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
Vadim Kalinin
Apr 07, 2017 at 08:11 PM

Can you explain with more details... Not clear!

0
Comment
avatar image
Vadim Kalinin Answered Feb 20, 2017 at 05:59 PM
0

You have to create a simple test case and provide screenshot. Also - what about type of Offline mode you are using?

Show 1 Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
Vadim Kalinin
Feb 20, 2017 at 06:01 PM

What is the User Option:

Other -> Static Offline Without Protection

0
Comment
avatar image
Sheryl Bourlier Answered Feb 20, 2017 at 06:45 PM
0

Part 1:

Screenshots:

  1. Unfiltered initial view

  1. Unfiltered, Offline Mode

  1. Filtered view, initial

  1. Filtered view, Offline Mode

Part 2:

User options as set (these are the same on both the Office 2010 machine and the Office 2016 machine.


tobvo.jpeg (52.1 kB)
4g1oc.jpeg (50.0 kB)
i7s2g.jpeg (57.6 kB)
v6psz.jpeg (60.6 kB)
sr6u5.png (98.5 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
Vadim Kalinin
Feb 20, 2017 at 07:00 PM

Sorry, but screenshots are in unreadable, low resolution!

Is it a "simple" test case?

0
Comment