XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/

Using Grids with Protected Worksheets

Revision as of 14:41, 4 July 2012 by Antonio.remedios (talk | contribs) (Made the link to the Microsoft page more specific)

XLCubed Grids can coexist with protected worksheets in several ways.

Using the Grid on the protected worksheet

The Grid may be placed directly on the worksheet that is to be protected. To do this, follow these steps:

  • On the Grid Properties > Appearance tab, deselect Apply formatting and Merge repeating cells
  • Set all the Grid cells to be unlocked. See this Microsoft article for details on how to lock and unlock specific cells.
  • If the Grid can be edited by drilling or other member selection methods, also unlock cells to accommodate the potential expansion.
  • Protect the sheet. At least the following options must be allowed:
    • Format cells
    • Format columns
    • Format rows

If Format columns and Format rows protection are desired, then Grid Properties > Behaviour > Resize columns/rows after refresh must be disabled.

Placing the Grid on a non-protected worksheet

The Grid can be placed on a non-protected worksheet, and the data brought to the protected sheet by using either:

  • The Camera tool (see this post for details)
  • Formulae

Alternatives

See Also