Skip to Content
0
Jul 04, 2012 at 08:18 AM

Locking cells on input templates for BPC v10 NW

13 Views

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.