Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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.

See also

Set or clear read-only status

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×