Lock cells feature in Analysis for Office - Excel

[former_member690380]

Hello,

I was trying to lock some cells in an AO Workbook, I tried to use the "Lock Cells" button in Analysis Tab(screenshot attached). But once a user refreshes the report, the locked cells become unlocked. So the feature is almost useless. Any ideas?

AO Version being used is 2.7.

[TammyPowlas]

Hello - I don't see your screen shot. Would you please insert/attach again?

Which version of Analysis Office are you using?

[former_member690380]

Hey Tammy, its been updated. thanks

AO Version is 2.7.

[gregor_dieckmann]

Hi Manish,

locked cells are controlled by the client (i.e. in Analysis Office) or by the server; the client does not know very much about the data this is why the locks of to be deleted after some 'actions' in Analysis Office. In general the locks are bound to the user session.

In the design panel on the 'Planning' tab you find the setting 'Cell Locking', the default is 'Front End Cell Locking'; if you want that the server controls the locked cells you should use 'Back End Cell Locking: Single Query'. The third setting 'Back End Cell Locking: Cross Query' should only be used in very special situations of 'related queries'.

In general I recommend to use the second setting.

Regards,

Gregor