XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Using Grids with Protected Worksheets"
(→Using the Grid on the protected worksheet) |
(→See Also) |
||
Line 23: | Line 23: | ||
==See Also== | ==See Also== | ||
+ | * [http://office.microsoft.com/en-us/excel-help/password-protect-worksheet-or-workbook-elements-HP010078580.aspx Password protect worksheet or workbook elements] | ||
* [http://office.microsoft.com/en-us/excel-help/lock-or-unlock-specific-areas-of-a-protected-worksheet-HA010096837.aspx Lock or unlock specific areas of a protected worksheet] | * [http://office.microsoft.com/en-us/excel-help/lock-or-unlock-specific-areas-of-a-protected-worksheet-HA010096837.aspx Lock or unlock specific areas of a protected worksheet] | ||
[[Category:Grid Reporting]] | [[Category:Grid Reporting]] | ||
[[Category:Report Management]] | [[Category:Report Management]] |
Revision as of 14:24, 4 July 2012
XLCubed Grids can coexist with protected worksheets in several ways.
Contents
[hide]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 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. 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