2665190 - Lock Cells button greyed out (disabled)

When you select more than 100 cells on a crosstab the lock cell button is greyed out.

Analysis for Office

Execute a query with more than 100 data cells. Select the full crosstab and check the lock button. It is greyed out.

This is a standard behavior and is based on the NrOfSingleCellsInContext parameter.

Tis situation is not only for lock cells button. The parameter NrOfSingleCellsInContext  defines the maximum number of crosstab cells that can be selected to execute analysis options, for example filtering. If more cells are selected in a crosstab, the analysis options are disabled. The default value is 100.

To enable the lock cell, please follow the steps below:

1.  Go to File

2.  Analysis

3. Click on Customize Analysis / Technical Configuration

4.  Select NrOfSingleCellsInContext  

5.  Increase the value of the parameter.

6. Restart Analysis for Office

Lock cell, button, greyed out, Analysis, parameter, disabled , KBA , BI-RA-AO-XLA , Excel Addin , How To