Excel Protect Sheet Edit Scenarios Explained

How-to basics · Updated November 21, 2026

In Excel for Microsoft 365 on Windows, the Edit scenarios option lets people use Scenario Manager on a protected worksheet. To allow it, go to Review > Protect Sheet, select Edit scenarios, and protect the sheet; if the sheet is already protected, unprotect it first and apply the permission again.

What “Edit scenarios” means

Excel’s Scenario Manager is a What-If Analysis tool for saving sets of input values and switching between them. For example, a sales forecast might have separate scenarios for lower, expected, and higher sales. Each scenario stores values for designated changing cells, such as units sold and average price, and applies those values to the worksheet so that formulas recalculate.

When you protect a worksheet, Excel can limit actions that would otherwise change its contents. The Edit scenarios permission is a specific exception for scenario management. It is separate from the more familiar permissions to select cells, format cells, sort a range, or use AutoFilter. It does not mean that every cell on the sheet becomes editable.

Scenarios are saved with the worksheet, so users can work with scenarios already defined there. The permission is useful when a workbook owner wants to keep a model’s layout and formulas protected while allowing colleagues to work with its saved What-If cases. It does not turn Scenario Manager into a general-purpose input form or give users permission to change every part of the model.

How to allow scenario editing

  1. If the sheet is currently protected, choose Review > Unprotect Sheet. Enter its password if Excel asks for one. You cannot change the protection options while the sheet remains protected.
  2. Open Review > Protect Sheet. In the protection dialog, leave Protect worksheet and contents of locked cells selected.
  3. In the list of permitted actions, select Edit scenarios. Select any other permissions only if users need them; for instance, Select unlocked cells is a separate option.
  4. Optionally enter a password to unprotect the sheet, confirm it if prompted, and choose OK. Keep the password somewhere secure if you will need to change the settings later.
  5. To work with a scenario, use Data > What-If Analysis > Scenario Manager. Select a listed scenario and use the available controls to view, edit, add, or delete scenarios.

If you are setting up the workbook from scratch, create and check the scenarios before protecting the sheet. Then protect it with the permissions appropriate for the people who will use it. On Excel for Mac, the commands and dialog wording can vary slightly by release, but use the sheet-protection controls on the Review tab and look for the scenario permission. Scenario Manager is a desktop Excel feature; if you do not see it in Excel for the web, open the workbook in the desktop app to manage scenarios.

How scenario permissions interact with locked cells

Worksheet protection relies on each cell’s Locked setting. Most cells are marked locked by default, but that setting only restricts editing after you protect the sheet. Scenario Manager also relies on changing cells: those are the cells whose values a scenario replaces. The distinction matters because permission to edit scenarios is not the same as permission to edit the changing cells directly.

Microsoft’s protection guidance notes an important limitation: when cells are protected, users can change only scenarios that do not use protected cells. If a scenario’s changing cells are locked, the scenario operation may be blocked even though Edit scenarios is selected. A practical setup is to unlock the scenario input cells before protecting the sheet, while leaving formula cells and labels locked. That gives users a defined area for inputs, although unlocked cells can also be edited directly.

To unlock the intended inputs, select them before protecting the sheet, open Home > Format > Format Cells, choose the Protection tab, clear Locked, and select OK. Then protect the sheet and enable the required permissions. If users should be able to select those inputs, also allow Select unlocked cells. Test with a copy of the workbook: protection behavior depends on which cells each scenario changes and which permissions are enabled.

A concrete forecasting example

Imagine a worksheet with cells for monthly orders and average order value, plus locked formulas that calculate revenue. A scenario called “Expected” might store 500 orders and an average value of $40; a “Lower” scenario might store 400 and $36. Selecting a scenario substitutes its saved values in the changing cells, and the protected revenue formula recalculates. The sheet owner can allow scenario work without allowing users to edit the formula that calculates revenue.

For this arrangement, set the two input cells as the scenario’s changing cells, unlock those cells if users need to apply scenarios while the sheet is protected, and keep the formula cells locked. Protect the sheet with Edit scenarios enabled. If users should not type directly into the inputs, recognize that unlocking them does not enforce scenario-only editing; Excel worksheet protection does not provide a separate rule that permits changing those cells exclusively through Scenario Manager.

Scenario Manager is also limited in scope: a scenario can use up to 32 changing cells. It is designed for comparing a small set of saved assumptions, not for storing a large collection of records or automating a complex planning process. For more extensive modeling, consider whether a structured input table, separate model copies, or another workflow is easier to maintain.

What this permission does not allow

  • It does not unlock the whole worksheet. Cell editability still depends on locked status and the other permissions selected in the protection dialog.
  • It does not protect the workbook file with strong security. Worksheet protection is intended to control editing, not to encrypt sensitive information or guarantee that a determined person cannot access it. Use file-level encryption and appropriate access controls for confidential data.
  • It is not the same as protecting workbook structure. Sheet protection governs actions on a worksheet. Workbook-structure protection controls changes such as adding, deleting, moving, or renaming sheets; its setting is separate.
  • It is not a general What-If Analysis permission. Scenario Manager, Goal Seek, and data tables are different tools. Do not assume that enabling Edit scenarios grants every operation in Data > What-If Analysis.

Also note that a Scenario Summary report is a separate output: Scenario Manager can create a summary on a new worksheet. If users need to create reports or alter other parts of the workbook, check those tasks independently instead of assuming the scenario checkbox covers them.

Common problems and fixes

  • Scenario Manager is unavailable or actions are disabled. Confirm that you are using desktop Excel, that the sheet’s protection settings include Edit scenarios, and that the scenario’s changing cells are not protected. If the sheet was protected before the permission was selected, unprotect it and apply the settings again.
  • Excel asks for a password. A protected sheet may require its password before you can change protection settings. Ask the workbook owner for access. If the password is unknown, Excel does not provide a supported way to recover it; avoid relying on unverified “unlock” methods.
  • Users can edit cells directly when you only wanted scenario changes. Check which cells are unlocked and which selection or editing permissions are enabled. Excel’s worksheet protection does not offer a perfect scenario-only interface for unlocked changing cells, so consider a separate input workflow if direct edits are unacceptable.
  • A scenario changes some values but not the expected output. Check that the scenario contains the intended changing cells and that output formulas refer to those cells. Scenario Manager stores values, not a separate copy of the workbook’s formulas or layout.
  • A user can select an input but cannot change it, or cannot select it at all. Selection permissions and edit permissions are distinct. Review Select locked cells, Select unlocked cells, the cell’s Locked setting, and whether the sheet is protected.

When troubleshooting, test the exact user task on a duplicate workbook with the same protection settings. This helps distinguish a scenario-definition issue from a locked-cell or permission issue without risking the working model.

Choosing a suitable setup

Use Edit scenarios when users need to work with a small number of saved alternatives while the rest of the worksheet remains protected. Decide first whether they need to create or change scenarios, whether those scenarios must alter protected inputs, and whether users may also type directly into those inputs. These questions determine whether to unlock changing cells and which other permissions to grant.

For a shared forecast, a common balance is to keep formulas and headings locked, unlock a clearly labeled input area, enable scenario editing, and document what each scenario represents. Keep an unprotected owner copy or a backup before changing protection settings. Protection can reduce accidental edits, but it does not replace version history, access controls, or a clear process for reviewing model changes.

Frequently Asked Questions

Can I edit scenarios without unprotecting the sheet?
Yes, if the sheet was protected with Edit scenarios enabled. However, scenarios that use protected changing cells may still be restricted. If a scenario cannot be applied, check the changing cells’ Locked settings and test the setup.

Does “Edit scenarios” let users edit locked cells?
No. It is a permission for scenario management, not a general cell-editing permission. A scenario that uses protected changing cells may not be changeable. Unlock the intended inputs if required, understanding that users may then be able to edit those cells directly.

How do I change the permission on a protected sheet?
Choose Review > Unprotect Sheet, enter the password if requested, and then choose Review > Protect Sheet to select Edit scenarios and any other needed permissions. Protect the sheet again.

Is “Edit scenarios” the same as allowing Goal Seek?
No. Scenario Manager saves and switches between sets of input values. Goal Seek works backward from a desired formula result to find an input value. The protection checkbox specifically refers to scenarios and should not be treated as permission for every What-If Analysis tool.

Can I use Scenario Manager in Excel for the web?
Scenario Manager is a desktop Excel feature. To create or manage scenarios, open the workbook in the desktop version of Excel. The available controls can differ across Excel versions and platforms.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.