cancel
Showing results for 
Search instead for 
Did you mean: 

Hiding Formulas in a report

0 Kudos

I am having an issue with a report where I want to have formulas hidden within an EPM 10 report in Excel 2013. I have attempted the Excel functionality, however when the report is refreshed I get "Unable to set the IndentLevel of the Range class" error. I originally posted this to the BPC MS 10 site but it was suggested I ask in the Microsoft site as this is probably an Excel VBA error and not BPC. HELP!

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member182034
Active Contributor
0 Kudos

hi Bill,

Please check these SAP Notes, specially first one. instruction might be resolved this issue.

2311160 - ALL: Refresh freezes application activities until completed

1776609 - EvDRE returns #ERR after set back to Live from Offline state

1383316 - Protected BPC template not working-BPC NW 7.X

0 Kudos

Using the process in 1383316 does prevent the error however when I refresh the worksheet unchecks the "hidden" protection box and makes the formula visible again even after I check the keep formulas static that reference report cells and Restore dynamic selection on refresh after navigation. Updating to SP25.3 hasn't resolved the issue either.

0 Kudos

Are you aware of any issues with BPC Administrator Maintaining Dimension members not working after loading SP25.3 64bit