How do I unprotect my spreadsheet?

The templates are not meant to be unprotected. If you're getting a message to unprotect, that means you're trying to edit in the wrong spot! Most templates have been "protected" in order to prevent accidental changes (such as typing over a formula).

But if you are purposely trying to change the way the template was built, read on for instructions on how to unprotect it.

Warning: If you unprotect the template, Savvy Spreadsheets can no longer be responsible for it working properly. If something breaks as a result of your changes, Savvy Spreadsheets may not be able to help you without charging a consulting fee.

Select the Review tab from the ribbon bar at the top of your screen (see image below). Then select "Unprotect Sheet."

 Click back to your spreadsheet. You may see a pop-up message, warning you that the template may not function properly.

If you accept that Savvy Spreadsheets will no longer be responsible for the template, click "Yes."

You are free to make whatever changes you want!

We recommend that you re-protect the spreadsheet after making your changes. To do this, click on "Protect Sheet" (in the same spot that "Unprotect Sheet" was in).

Go back to FAQ.