Front-end cell locks in a query remain in effect until the user makes significant changes to the crosstab.
Sorting the crosstab
Expanding or collapsing nodes in BW hierarchies
Changing display settings for dimensions
If the user performs one of the following activities though, the cells locks are undone: :
Adding/removing dimensions or measures to the crosstab
Calling the prompting dialog to change variable values
Swapping row and column axes
Hierarchical axis display
Zero suppression
Setting a filter
Executing a planning function or sequence