Worksheet Status - Locked versus Unlocked

Locking Worksheets

When actively budgeting, a worksheet is unlocked and users are updating it. Once it has been submitted, the worksheet will be automatically locked, and no further changes can be made to the worksheet or an associated special purpose worksheet. It is recommended that all worksheets in a budget stay locked once the budget has been approved to prevent accidental changes.

Locking Versus Freezing

When a budget is frozen, all months up through the current Last Closed Month are frozen and cannot be modified, for all worksheets in the budget. Approved and reforecast budgets are typically frozen. Non-frozen months can be modified if the worksheet is unlocked. 

Locking and Unlocking from the Worksheet

A Martus Admin or any non-admin user who has "Can Unlock Worksheets" on their User Permissions can lock or unlock a worksheet.

1. Start on Planner > Worksheets.
2. Click Edit (pencil icon) next to any worksheet.
3. Click the Lock icon to unlock/lock the worksheet.
   OR
4. Go to Worksheet Actions > Submit and Lock or Unlock.
   
   

Locking and Unlocking from Planner Setup

A Martus Admin can lock or unlock all or specific worksheets from Planner > Planner Setup.

Unlocking/Locking all worksheets in a budget:

1. Start in Planner > Planner Setup.
2. Select the check box for the appropriate budget.
3. Click on Lock Worksheets or Unlock Worksheets.
   
   
   

Unlocking/Locking one or more worksheets in a budget:

1. Start on Planner > Planner Setup.
2. Go to the Worksheet Management tab.
3. Select one or more worksheets.
4. Click on Unlock or Lock.