Excel Guides

Opening a Workbook as Read-Only in Excel

When you open a workbook in Excel, it will open as read-only by default if the file is located in a read-only location or if the workbook is protected by a password. You can also open a workbook as read-only by using the Open dialog box or by using the keyboard shortcut CTRL + O. To open a workbook as read-only, do the following:

  1. Click the File tab, and then click Open.
  2. In the Open dialog box, locate the workbook that you want to open.
  3. Click the workbook, and then click Open.
  4. Click Read-Only in the message that appears.

If you try to save a read-only workbook, Excel will display a message asking if you want to save a copy of the workbook. If you click Yes, you can save the workbook with a new name or in a different location. If you click No, your changes will be discarded.

Move beyond 


Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.