AX2767
Removing workbook and worksheet protections
Axiom Budget Planning and Performance Reporting applies a variety of workbook and worksheet protections to Axiom files. If you have the appropriate user rights, you can temporarily remove the workbook or worksheet protections using the unprotect options that are available on the Axiom ribbon.
NOTE: The workbook and worksheet protection toggles allow users to temporarily remove and then reapply the protection settings of the existing file. If the sheet or file is not already configured on the Control Sheet to enable protection, selecting these options does not change that configuration. To enable protection for a sheet or a file, use the Control Sheet settings.
Remove worksheet protection
If a sheet is protected, you can temporarily unprotect it:
On the Axiom tab, in the Advanced group, click Protect > Worksheet to remove the check mark.
NOTE: In systems with installed products, this feature may be located on the Admin tab, either directly on the ribbon or under File Protection.
You can now edit the sheet. If you do not have rights to remove worksheet protection, this item is not displayed on the menu.
The sheet protection is automatically reapplied the next time the file is opened. To reapply it, click Protect > Worksheet again to toggle the protection on.
The Control Sheet settings for an Axiom file determine whether protection is enabled for a sheet. Sheet protection is most often applied to plan files and templates, but you can also apply them to driver files and reports as needed. Protection is always applied to Control Sheets.
If a workbook is protected, you can temporarily unprotect it:
On the Axiom tab, in the Advanced group, click Protect > Workbook to remove the check mark.
NOTE: In systems with installed products, this feature may be located on the Admin tab—either directly on the ribbon or under File Protection.
You can now make structural changes to the workbook, such as unhiding sheets or adding sheets. If you do not have rights to remove workbook protection, this item is not dislayed on the menu.
The workbook protection is automatically reapplied the next time the file is opened. To reapply it, click Protect > Workbook again to toggle the protection on.
For report files and driver files, the Control Sheet settings determine whether workbook protection is enabled for the file. For plan files, workbook protection is applied automatically.
NOTE: For plan files, any structural changes you make to the file should be temporary (such as unhiding the Control Sheet to troubleshoot an Axiom query). If you delete or rename sheets, you may impact Axiom query settings and use of calc method libraries. As a best practice, make structural changes to plan files in the template and not the individual plan files.
Remove all protection
Users with the appropriate permissions can turn off all protections and display controls at the same time by clicking Show Everything on the Axiom Designer tab.
NOTE: In systems with installed products, this feature may be located on the Admin tab, either directly on the ribbon or under File Protection.
