Enable Editing in Excel: Exit Protected View

How-to basics · Updated November 20, 2026

To close Excel’s Enable Editing prompt and start editing, open the workbook and select Enable Editing on the Protected View message bar. If you do not want to enable editing, leave the workbook in Protected View and close it instead. The button does not close Excel or the workbook; it changes the workbook from a protected, read-only state to an editable one.

What You’ll Need

  • Excel for Microsoft 365 on Windows, or access to the workbook in another Excel version. The labels and layout can differ slightly on Mac and in Excel for the web.
  • The workbook file, plus permission to edit it. If it belongs to someone else or is stored in a managed workplace location, you may need the owner or administrator to grant access.
  • A reason to trust the file and its source. Protected View is a security feature, so do not enable editing just to remove the banner if you are unsure where the file came from.

Step-by-Step

  1. Open the workbook and identify the message. In Excel for Microsoft 365 on Windows, a file opened in Protected View usually shows a colored message bar near the top of the workbook. It explains that the file came from a potentially unsafe location and includes an Enable Editing button. The workbook may still be readable, but editing is restricted. Check that this is the message you want to dismiss; other Excel notifications, such as a read-only notice or an editing permission warning, need different fixes.
  2. Check that the file is safe to edit. Consider who sent it, whether you expected it, and whether its name and contents make sense. If it arrived as an email attachment, verify the sender through a separate trusted channel when anything seems unusual. Files downloaded from websites, shared folders, or email can be flagged because of their origin. Do not enable editing for an unexpected file simply because the workbook looks familiar. If you are uncertain, close it and ask the sender for a safe copy or confirmation.
  3. Select Enable Editing. When you are satisfied that the file is trustworthy, click Enable Editing on the Protected View bar. Excel exits Protected View and allows normal editing, subject to any other restrictions on the workbook. The message bar should disappear or change. Click into a cell and make a harmless test, such as selecting a blank cell, to confirm that the workbook is editable. You do not need to select a separate Close button for the banner.
  4. Save your work if you make changes. Use File > Save, or press Ctrl+S on Windows. If Excel asks you to choose a location or file format, read the prompt before continuing. A downloaded or emailed file may be best kept as a separate copy: use File > Save As and choose a folder and filename you recognize. Saving a copy can preserve the original attachment, but it does not prove the file is safe or remove every kind of restriction.
  5. Close the workbook when you are finished. After saving, choose File > Close or click the workbook window’s close button. If Excel asks whether to save changes, choose Save to keep them, Don’t Save to discard them, or Cancel to return to the workbook. Closing the workbook is separate from enabling editing: first you leave Protected View, then you edit or review the file, and finally you close it.
  6. If you only want to dismiss the prompt without editing, close the file. Do not select Enable Editing. Use File > Close or close the workbook window. If you opened the file by mistake, this is the simplest way to leave Protected View without changing the workbook. If Excel asks about unsaved changes, decide whether to save, discard, or cancel; a file that has only been viewed may not have any changes to save.

Common Mistakes

  • Looking for a separate Close button on the banner. The usual Protected View bar offers Enable Editing, not a command that closes the bar while keeping the workbook protected. To keep the file protected, leave the button alone and close the workbook. Selecting Enable Editing exits that protected state.
  • Assuming the button is a security scan. Enable Editing changes what you can do in the workbook; it does not certify the file as safe, scan it for malware, or verify its sender. Make the trust decision before clicking.
  • Confusing Protected View with workbook protection. A sheet or workbook can still have protection after Protected View ends. If Excel lets you select cells but not change them, the sheet may be protected or your account may lack permission. The banner is not the only possible cause of editing restrictions.
  • Expecting macros to run after enabling editing. Enabling editing does not automatically enable macros or remove every security warning. Treat macro prompts as a separate decision, particularly for files from unknown sources.
  • Changing Trust Center settings just to remove one banner. Turning off Protected View broadly can expose you to risky files in the future. Prefer enabling editing only for a file you have checked rather than weakening protections for every workbook.

Tips

  • Use the source, not just the file extension, to judge risk. An .xlsx file can still contain misleading or harmful content, and a familiar filename can be copied. Check the sender, download location, and whether you were expecting the workbook.
  • Keep an untouched original when appropriate. For an important attachment, use File > Save As to work on a clearly named copy. This helps you compare versions or return to the original if you make unwanted changes. It does not bypass access controls or make an untrusted file safe.
  • Know the Windows shortcut and its limit. Ctrl+S saves changes in Excel for Windows; it does not enable editing or close the workbook. On Mac, use Command+S to save. There is no keyboard shortcut you need to use instead of the Protected View button.
  • On Mac, look for the equivalent Protected View notice. Excel for Mac can also restrict files opened from potentially unsafe sources. Review the message and select its Enable Editing option only if you trust the file. Exact wording and placement can vary by Excel build and organizational settings.
  • In Excel for the web, check the editing mode. The browser version may show that the workbook is in viewing mode or that you have read-only access, rather than showing the same desktop Protected View bar. Use the available Edit or Open in Desktop App option only if your account has permission. If there is no editing option, ask the file owner to grant access.

Troubleshooting

The Enable Editing button is missing. Look for a different message at the top of the workbook. It may say the file is read-only, that editing is restricted, or that the workbook is protected. If the file opens in Excel for the web, the desktop Protected View banner may not appear at all. Check the window title and the message bar, then use the instructions for the restriction actually shown rather than changing security settings at random.

I clicked Enable Editing, but cells are still not editable. The workbook may have a protected sheet, protected workbook structure, read-only permissions, or an organizational access policy. Check Review > Protect Sheet for the sheet protection controls; if the sheet is protected, you may need the password or help from the person who created it. For a shared file, check whether you are signed in to the account that has edit access. Enabling editing in Protected View does not override passwords or permissions.

Excel still opens the file in Protected View every time. That can happen when the file continues to be treated as coming from an untrusted source. If you trust the specific workbook, use its Enable Editing button each time it appears, or ask your IT administrator about the organization’s approved process. Windows file properties may offer an Unblock option for some downloaded files, but only use it after verifying the file and following your organization’s policy. Avoid turning off all Protected View settings as a general workaround.

Excel says the file is locked or another person is editing it. This is different from Protected View. For a shared workbook, wait for the other person to finish, ask them to close it, or request your own edit access. If Excel offers to open a read-only copy, you can view it, but changes may not be saved back to the original. Do not create competing copies unless you know how the owner wants edits collected.

I cannot decide whether the file is safe. Close it without enabling editing and contact the sender using a known email address or another trusted method. If it came from a work account, follow your organization’s security process or ask IT. Do not enable editing to inspect suspicious content; if needed, request a verified replacement file.

Frequently Asked Questions

How do I close the Enable Editing bar without enabling editing?
In the usual Protected View workflow, there is no separate dismiss button that leaves the workbook open in the same protected state. Leave the bar untouched and close the workbook. If you click Enable Editing, Excel exits Protected View.

Does clicking Enable Editing save the workbook?
No. It allows editing but does not itself save your changes. Use File > Save or Ctrl+S on Windows after making changes. On Mac, use Command+S.

Can I enable editing for just one workbook?
Yes. Clicking the button on that workbook allows you to work with that file; it does not require you to disable Protected View for all files. Avoid changing global security settings unless your organization’s administrator directs you to do so.

Why does Excel show Enable Editing?
Excel may open a workbook in Protected View when it comes from an internet download, email attachment, or another location Excel treats as potentially unsafe. The message is a warning and a choice, not proof that the file is dangerous or harmless.

Will enabling editing turn on macros?
No. Editing access and macro security are separate. A macro-enabled workbook may still have macros blocked or show a separate security notice. Only allow macros when you trust the source and understand why the workbook needs them.

Can I do this in Excel for the web?
Excel for the web may use viewing and editing permissions instead of the desktop Protected View banner. If you see a viewing-only state, use the available edit option if you have permission; otherwise, ask the owner to grant it or open the file in the desktop app if that is allowed.

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.