on 07-04-2012 9:18 AM
Hi All,
We would like to be able to lock the cells of an input template for the flow (subaccount) analysis on BPC v10 NW.
We have tried using locking functionality on the EPM formatting sheet. This functionality works as expected, but the locking for the EPM formatting sheet is based on the columns OR rows and not a combination of the columns AND the rows.
For example, we have an input temple for PPE accounts on the balance sheet. The rows of the report have "Land", "Buildings", "Machinery", etc. The columns contain movements such as "Increase/Purchase", "Decrease/Disposal", "Depreciation", etc. When the report is refreshed, we would like it to dynamically lock the crossing between the account "Land" and the flow "Depreciation", but leave the other cell that are valid dimension crossing as updateable.
We have also tried using the data validation function of Excel, but this function is not compatible with the new EPM reports in v10.
Any help on this would be greatly appreciated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
10 | |
9 | |
5 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.