Unlocking a Spreadsheet

To unlock the currently selected spreadsheet, follow these instructions:

Procedure

  1. From the Tools tab or menu, select Locking to display the Lock Spreadsheet dialog box.
  2. In the Prevent changes to box, clear the check box corresponding to the features you need to unlock. For example, if you need to adjust the Case Selection Conditions, clear the Case selection and weights check box. If prompted, you might need to enter the correct password before you can clear any check boxes.
  3. Click OK to unlock the cleared spreadsheet features.