Prompt to open a workbook as read-only

If you want to remind everyone that a workbook should only be changed if necessary, you can recommend that the workbook be opened as read-only.

Note: Prompting to open as read-only will not prevent changes from being made to your workbook. For stronger protection, set read-only status by locking the workbook with the Finder, or require a password to save changes.

  1. Open the workbook you want to protect.

  2. Click the File menu, and then click Passwords.

    Password option in the File menu
  3. In the File Passwords dialog box, select the Read-only recommended check box, and click OK.

  4. Close the workbook.

    The next time the workbook is opened, a message will ask if you want to open as read-only.

  1. Open the workbook that you want to protect.

  2. On the Review tab, under Protection, click Passwords.

    Review tab, Protection group

  3. In the File Passwords dialog box, select the Read-only recommended check box, and click OK.

  4. Close the workbook.

    The next time the workbook is opened, a message will ask if you want to open as read-only.

See also

Restricting changes by using read-only status

Set or clear read-only status

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×