on 06-03-2016 7:00 PM
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!
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
80 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.