In Excel for Microsoft 365 on Windows, choose File > Open > Browse, select the workbook, then click the arrow beside Open and choose Open Read-Only. This opens the file so you can review it without saving changes over the original. You can also set a workbook to recommend read-only opening or use file permissions, but those options behave differently and do not all provide strong security.
Before you start, decide whether you need read-only access just for this session, want Excel to recommend it each time, or need to limit who can change the file. The steps below focus on the Windows desktop version of Microsoft 365. Read-only mode helps prevent accidental edits; it is not a substitute for access controls or a backup.
What You’ll Need
- Excel for Microsoft 365 on Windows and the workbook you want to open.
- Permission to access the folder, shared drive, or cloud location where the workbook is stored.
- If you plan to change the file’s default opening behavior, permission to save changes to the workbook or its file properties.
If the workbook is on OneDrive, SharePoint, or a company network, your account’s permissions and other people’s access may affect what you can do. The owner or administrator may need to grant view-only access.
Step-by-Step
-
Open Excel and go to the Open screen. Start Excel, or switch to Excel if it is already running. Select File in the upper-left corner, then select Open. If you see the workbook in the recent-files list, do not simply click its name; use Browse so you can choose the read-only command from the file dialog.
-
Browse to the workbook. In the Open window, navigate to the folder containing the Excel file. Select the file once so its name is highlighted. You do not need to open it by double-clicking.
-
Choose Open Read-Only. Find the Open button at the bottom of the dialog. Select the small arrow beside it, then choose Open Read-Only from the menu. Excel opens the workbook in read-only mode. Depending on the workbook and Excel build, the title bar or a message near the top may indicate that it is read-only.
-
Review the workbook without overwriting the source. You can move between sheets, select cells, use filters, and inspect formulas. If you try to edit a cell, Excel may block the change or let you make a temporary change that cannot be saved over the original. If you need an editable version, use File > Save As and save a copy under a different name or in a different folder. Check the destination and filename before saving so you do not replace the source by mistake.
-
Optionally recommend read-only opening for future sessions. If you own the workbook and want Excel to prompt people to open it read-only, open it normally, then choose File > Info > Protect Workbook > Always Open Read-Only. Save the workbook to keep the setting. The wording or availability can differ in other Excel versions. This is a recommendation, not a lock: a person who can edit the file may be able to choose to edit it anyway.
-
Optionally make the file read-only in Windows. Close the workbook first. In File Explorer, right-click the workbook and choose Properties. On the General tab, select the Read-only checkbox, choose Apply, and then choose OK. Reopen the file in Excel. To allow changes later, close it, return to the same Properties dialog, clear the checkbox, and apply the change. This file attribute can be changed by someone with suitable access; it is not a secure way to restrict other users.
On a Mac: The Windows Open dialog’s arrow and Open Read-Only command may not be presented the same way in Excel for Mac. For a file you control, close the workbook, locate it in Finder, choose File > Get Info, and select Locked under General. This is a Finder file lock, not the same setting as Excel’s read-only recommendation; clear it in Get Info when you need to edit the file. For shared files, use the owner’s view-only sharing permissions. Excel for the web also relies on sharing permissions rather than the Windows desktop Open Read-Only menu.
Common Mistakes
-
Clicking the workbook in Recent instead of using the Open menu. A normal click may open the file in its usual mode. To use the one-session option, go through File > Open > Browse and choose the arrow beside Open.
-
Assuming Always Open Read-Only prevents every edit. It asks Excel to recommend read-only opening. It does not stop an authorized user from choosing to edit the workbook, and it does not prevent someone from making a separate copy.
-
Confusing a read-only file attribute with permission security. The Windows checkbox is a useful safeguard against accidental saves in some situations, but someone who can change the file properties may clear it. Use OneDrive, SharePoint, or folder permissions when you need to control who can edit the shared original.
-
Saving a copy into the source folder with the same name. When Excel cannot save changes to the original, Save As may be the right workaround. Give the copy a distinct name and verify the location so you do not overwrite the workbook you meant to preserve.
-
Ignoring a lock caused by another person. If Excel says the file is locked for editing or that another user has it open, that is not necessarily the same as choosing Open Read-Only yourself. Do not delete temporary lock files from a shared folder; ask the person using the file or your administrator before changing anything.
Tips
-
Use Open Read-Only when you only need to inspect a workbook once. It leaves the workbook’s saved opening preference unchanged.
-
Use Always Open Read-Only when you distribute a reference workbook and want to remind recipients not to edit the original. Add a clear note explaining where to save a working copy.
-
For files shared through OneDrive or SharePoint, ask the owner to grant Can view rather than Can edit if you should not change the shared original. The exact sharing controls depend on the organization’s settings.
-
If the workbook contains important information, keep a separate backup. Read-only mode reduces the chance of an accidental overwrite, but it does not protect against deletion, replacement, or changes made by someone else.
-
When you need to annotate or analyze the data, save a separate copy first. That gives you room to edit, sort, or filter without changing the source workbook that other people rely on.
Troubleshooting
I cannot find Open Read-Only. Confirm you are in Excel for Windows and opened the full file picker through File > Open > Browse. Select the workbook once, then use the small arrow beside the Open button. If you are using Excel for the web, a Mac build, or a simplified file picker, use view-only sharing permissions or the relevant file-level option instead.
The workbook still lets me type. Read-only behavior can vary: a read-only recommendation is only a prompt, and a file attribute or shared-file lock may still allow some temporary editing. Check whether Excel displayed a read-only notice, and look at the title bar or workbook information for a read-only indication. If you need to protect a shared original, ask its owner to remove your edit permission rather than relying on the recommendation setting.
I can edit, but Excel will not save over the workbook. This is expected when the file is opened read-only or you have view-only access. Choose File > Save As and select a location where you have write permission. Use a new filename, then confirm the copy opens and contains your changes before closing the original.
The Read-only checkbox is unavailable or does not stay selected. The workbook may be on a network or cloud location where you cannot change file attributes, or your account may not have permission to change them. Ask the folder owner or administrator to adjust access. If the file is actively syncing, wait for synchronization to finish before changing properties.
Excel says the file is locked or in use. If appropriate, ask the listed user whether they are still editing it. If the user has closed Excel but the message persists, allow time for a network or cloud lock to clear, then try again. Avoid deleting lock or owner files yourself, especially on a shared drive, because that can interfere with another person’s active session.
I need view-only access in Excel for the web. Ask the file owner to share the workbook with viewing permission, or to change your existing permission from editing to viewing. If you own the file, open its sharing controls and check the link or person-specific access settings. Organization policies can limit which options appear.
Frequently Asked Questions
Can I edit a workbook after opening it read-only?
Usually you can inspect it, but you cannot save changes over the protected or read-only original. Use File > Save As to create a separate editable copy if you have permission to save in the destination.
Does read-only mode stop someone from copying the workbook?
No. Read-only is intended to reduce edits to the original, not prevent copying, screenshots, or sharing. Use appropriate access controls and organizational policies for sensitive information.
How can I tell whether a workbook is read-only?
Excel may show a read-only message or status near the top, and the title bar or file information may identify the file as read-only. If you are unsure, try saving a separate copy rather than testing by overwriting the source.
What is the difference between Open Read-Only and Always Open Read-Only?
Open Read-Only is a choice for opening a particular session. Always Open Read-Only saves a recommendation in the workbook so Excel prompts users in later sessions; it does not enforce view-only access.
Can I make a workbook read-only for everyone?
Not reliably with the read-only recommendation alone. For a shared workbook, ask the owner or administrator to assign view-only permissions. File attributes can help prevent accidental changes, but users with sufficient access may be able to change them.
Related
- How to Insert an Image Into Excel and Position It
- How to Add an Image Link to an Excel Cell in Microsoft 365
- How to Insert an Image in Google Sheets: Quick Steps
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- IFS Formula in Google Sheets: How to Use ItUse the IFS function in Google Sheets to test conditions in order and return the value for the…
- Excel: Turn Off Page Break Preview and Restore Normal ViewTo turn off Page Break Preview in Excel for Microsoft 365 on Windows, select View > Workbook Views…
- Can You Import Excel and CSV Files Into QuickBooks?Yes. QuickBooks can import Excel and CSV files for certain kinds of data, but the accepted format depends…
- Center a Number in Excel: Steps, Options, and FixesTo center a number in Excel for Microsoft 365 on Windows, select the cell or cells, then choose…
- Excel Data Validation List Based on Another Cell ValueYes. In Excel for Microsoft 365 on Windows, select the cell for the dropdown, then choose Data >…
- Excel Shortcut Keys: Essential Windows and Mac KeysExcel has no dedicated keyboard shortcut for the NOT function; use the function in a worksheet formula instead.…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.