Skip to Content
Former Member
Feb 27, 2007 at 07:39 PM

Protecting columns in workbook - IP Planning


Hi All,

I have a question on planning using a workbook(BI-IP).

The workbook contains an input ready query (on a multiprovider) which has actuals columns and plan columns.

Is there a way to protect the actuals columns in order to prevent the user from changing values(display only).

When I select the option 'Enable Cell protection' within the dataprovider config it still allows the user to change values in the actual columns of the workbook which is confusing to the enduser. Protecting the worksheet temporarily diasables input in the actuals columns but gets refreshed each time the workbook is executed.

It works fine on the web where the actuals are greyed out.

Support pack is SP9.