How to Save an Excel File in Read-Only Mode: Steps

How-to basics · Updated November 20, 2026

To make an Excel workbook open with a read-only prompt, use File > Save As > Browse, then choose Tools > General Options in the Save As dialog and select Read-only recommended. This encourages people to avoid editing, but it does not prevent them from choosing to edit or saving a separate copy. To restrict editing more strongly, use a password to modify the workbook or give people view-only access through OneDrive or SharePoint.

What You’ll Need

Before you start, keep the following in mind:

  • A desktop version of Excel with the workbook open, or a saved copy you can edit.
  • Permission to save changes in the folder or cloud location where the workbook belongs.
  • If you need editing to be restricted rather than merely discouraged, decide whether you can use a password or manage sharing permissions.
  • If the workbook contains macros, retain its macro-enabled format, such as .xlsm, when saving. Do not change it to .xlsx unless you intend to remove the macros.

Step-by-Step

  1. Open the workbook and save a working copy if needed. Start Excel and open the file. If you want to keep an editable original, choose File > Save As and save a separate copy with a clear name, such as Quarterly Report – read only. This gives you a version to work on later without changing the original. Keep the current file type unless you have a reason to convert it.

  2. Open the full Save As dialog. In Excel for Microsoft 365 on Windows, select File > Save As > Browse. Choose the folder and file name for the copy. Do not click Save yet; the additional setting is in the dialog that appears after Browse, not in the workbook grid.

  3. Open General Options. In the Windows Save As dialog, find the Tools menu near the Save button, select it, and choose General Options. If the Tools menu is not visible, enlarge the dialog or check the small drop-down beside the Save button. The option is part of the desktop Save As dialog, rather than a command on the Home ribbon.

  4. Select Read-only recommended. In the General Options window, tick Read-only recommended. Leave the password fields blank if your goal is only to ask people to open the file without editing. Click OK to return to the Save As dialog.

  5. Save the workbook and confirm the setting. Click Save. If Excel asks whether to replace a file with the same name, verify that you selected the intended copy before confirming. Close the workbook, then reopen the saved file to check the result. Excel should show a prompt recommending read-only access. A reader can still choose to edit the file, so this is a reminder, not a lock.

  6. Use a password to modify if you need a stronger editing barrier. Return to File > Save As > Browse > Tools > General Options. Enter a password in Password to modify, select Read-only recommended if you also want the prompt, and click OK. Excel will ask you to confirm the password; enter it again exactly, then save. When someone opens the workbook, they can enter the password to edit or choose the read-only option, depending on the prompt shown. Keep the password somewhere secure: losing it can prevent authorized editing.

  7. Set view-only access for a shared cloud workbook. If the file is stored in OneDrive or SharePoint, use the Share controls to give recipients Can view rather than Can edit access. Review the link settings before sending it, because an existing link may already allow editing. This is usually a better choice for a group than asking each person to honor a read-only prompt. It controls editing through that shared location, but does not necessarily stop someone from downloading or copying the workbook.

In Excel for Mac, the Save As dialog has a different layout. Open File > Save As and look for Tools or Options and then General Options; the exact placement can vary by Excel build. If you cannot find a read-only recommendation option, use view-only sharing in OneDrive or SharePoint, or consult the password options available in your version of Excel. Excel for the web does not provide the same desktop General Options dialog, so set access through the file’s cloud sharing settings instead.

Common Mistakes

  • Assuming Read-only recommended blocks editing. It only asks the recipient to open the workbook as read-only. The recipient can usually choose to edit anyway, so do not use this setting to protect confidential or important data.

  • Confusing worksheet protection with read-only access. Review > Protect Sheet protects specified cells or worksheet actions; it does not make the whole workbook read-only. Likewise, Review > Protect Workbook can protect workbook structure, but it is not the same as controlling who can edit a shared file.

  • Using Mark as Final as a security measure. The File > Info > Protect Workbook > Mark as Final command signals that a workbook is finished and discourages changes. A reader can remove that status and edit, so use it as a status notice rather than access control.

  • Saving over the only editable copy. Read-only prompts and passwords can complicate later changes. Keep a clearly named working copy, and verify the file name and folder before replacing an existing workbook.

  • Expecting a file property to enforce permissions. Setting Read-only in Windows File Explorer’s file properties may discourage edits on that computer, but it is not dependable access control. A user with suitable permissions may change the property or create another copy.

Tips

  • Pick the least restrictive option that meets your goal. Use Read-only recommended for a polite reminder, a password to modify when people may view the file but editing should require a password, and view-only sharing permissions when managing a shared copy.

  • Keep passwords separate from the workbook. Share an editing password only with people who need it. A password to modify is not the same as a password to open: someone who can open the file may still be able to read its contents. For private information, consider a password to open or appropriately restricted storage as well.

  • Test with a second opening. Close the file and reopen the saved copy, or ask a colleague with the intended access level to check it. Confirm that the prompt or permission behaves as expected before distributing a link widely.

  • Use clear file names and locations. A name such as Budget-Approved-ViewOnly.xlsx helps distinguish a published copy from the editable source. If you update the source later, check that you are also updating the correct shared or read-only copy.

  • Remember what read-only means for saving. People may still be able to use Save As to create another file they can edit. If the goal is to protect the shared master, control its permissions and keep an authoritative copy in a location where only designated people can edit.

Troubleshooting

  • No read-only prompt appears. Check that you selected Read-only recommended in General Options and saved the workbook afterward. Reopen the exact file you saved, not the original or another copy with a similar name. If the file is opened in Excel for the web, the desktop prompt may not appear; use sharing permissions instead.

  • The Tools menu is missing. Confirm that you chose File > Save As > Browse and are looking at the Windows file dialog. Maximize or widen the dialog and inspect the small menus near Save. If you are using Excel for the web, save or open the file in the desktop app to use desktop General Options.

  • Someone can still edit the workbook. That is expected with Read-only recommended and Mark as Final. To require a password for editing, add a password under Password to modify. For a shared OneDrive or SharePoint file, change the recipient’s permission from Can edit to Can view and review any other links that grant editing access.

  • A password does not work. Check capitalization and keyboard layout, and make sure you are entering the password to modify rather than a password to open. If the password was lost, try to locate the saved password or an earlier unprotected copy. Excel cannot reliably recover a forgotten password to modify; do not overwrite the only copy while trying different settings.

  • You cannot save the file. Check that you have write permission to the destination, that the file is not open in a way that prevents saving, and that the folder is available. Save a new copy to a location where you have permission, then apply the read-only setting to that copy.

Frequently Asked Questions

Does Read-only recommended stop people from changing my Excel file?
No. It displays a recommendation, and a person can choose to edit anyway or save a separate copy. Use a password to modify or file-sharing permissions if editing must be restricted.

Can someone save changes to a read-only workbook?
They may be unable to overwrite the original in some circumstances, but they can often use Save As to create an editable copy. The exact result depends on the password setting, file location, and their permissions. A view-only cloud link controls the shared file, not every copy a recipient might make.

Can I make just one worksheet read-only?
You can protect a worksheet using Review > Protect Sheet and choose which cells can be edited. That protects selected parts of a workbook, rather than setting the entire file to read-only. It is useful for limiting accidental changes but should not be treated as strong security for sensitive data.

Is Mark as Final the same as read-only mode?
No. Mark as Final labels the workbook as finished and discourages editing, but users can remove the final status. Read-only recommended also acts as a prompt. Neither option alone enforces access restrictions.

Can I make an Excel file read-only in Excel for the web?
You cannot use the desktop General Options dialog in Excel for the web. If the workbook is in OneDrive or SharePoint, open its sharing settings and give the intended recipients view-only access. Use the desktop Excel app if you specifically need a password-to-modify setting.

Will read-only settings protect the workbook’s contents?
Not necessarily. A read-only prompt or view-only permission is mainly about preventing edits to the shared original. It does not automatically hide data or prevent every copy or screenshot. Use appropriate access controls for sensitive information, and share only with people who should be able to see it.

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.