To open a workbook without saving changes over the original, start Excel for Microsoft 365 on Windows, go to File > Open > Browse, select the workbook, click the arrow beside Open, and choose Open Read-Only. This is a one-time choice for that opening. You can also set a workbook to recommend read-only opening or use file permissions, but those options work differently and are not a substitute for access security.
Read-only is useful when you want to inspect a spreadsheet, avoid accidentally changing a shared file, or keep a source workbook intact while reviewing its contents. It does not hide information or encrypt the file. If you need to prevent other people from viewing or editing sensitive data, use appropriate sharing permissions and protection rather than relying on a read-only prompt.
What You’ll Need
- Microsoft Excel for Microsoft 365 on Windows for the main steps below. Older desktop versions have similar options, though their dialogs may look different.
- The workbook’s location and permission to view it. For a shared workbook, your OneDrive, SharePoint, or network permissions may control what you can do.
- If the workbook is already open, save any changes you want to keep before closing it and reopening it read-only.
Step-by-Step
- Close the workbook if it is already open. Excel’s read-only choice is made while opening a file. If you have unsaved edits, choose whether to save them before closing. If you do not want to change the original, avoid saving over it; you can discard edits or save a separate copy if needed.
- Open the file picker in Excel. Launch Excel, select File, choose Open, and then select Browse. Browse to the folder containing the workbook. You can also use Ctrl+O in Windows to get to the Open screen, then choose Browse if the file is not listed. On a Mac, Command+O opens the file dialog; the available read-only control can vary by Excel build and macOS file picker.
- Select the workbook without opening it yet. Click the file once in the Browse dialog. Do not double-click it, because that may open it using the normal mode before you can choose the read-only option.
- Choose Open Read-Only. Click the small arrow next to the Open button, usually at the lower-right of the dialog, and select Open Read-Only from the menu. The workbook should open in Excel. If the dialog does not show the arrow, check that you are using Excel’s Browse dialog rather than opening the file directly from File Explorer.
- Confirm the workbook is the one you meant to open. Check its name and location in Excel. Depending on the workbook and Excel version, the title bar may indicate read-only status or Excel may show a read-only notification. Try not to rely on a particular label alone; the key point is that you chose Open Read-Only in the file dialog.
- Review the workbook without saving over the source. You may be able to make temporary edits in the open session, but Excel will not let you replace the original file through an ordinary save if it is genuinely read-only. If you need to keep your own changes, use File > Save As and give the copy a different name or location. Close the original without saving if you only meant to inspect it.
Make a workbook recommend read-only opening
If you own the workbook and want Excel to ask people whether they want to open it read-only, use the workbook-level setting in desktop Excel for Windows. Open the workbook, choose File > Info > Protect Workbook > Always Open Read-Only, and save the workbook. When someone opens it, Excel can present a prompt to open it read-only or continue editing. This is a recommendation, not a lock: a person may be able to choose to edit, and it does not replace file permissions. To turn the recommendation off, return to the same menu and switch the setting off, then save.
Use a file-level read-only setting in Windows
To mark a local workbook read-only in Windows, close it first, open File Explorer, right-click the file, and choose Properties. On the General tab, select the Read-only checkbox under Attributes, choose Apply, and then choose OK. Reopen the file in Excel. This setting can help prevent accidental saving over that file, but it is not a strong security barrier: someone with suitable access can remove the attribute or save a copy. To make the file editable again, return to Properties and clear the checkbox.
Mac and Excel for the web
In Excel for Mac, look for a read-only option in the file-opening dialog if your version displays one. If it does not, close the workbook, locate it in Finder, choose File > Get Info, and select Locked under General. Reopen the workbook. The exact behavior can depend on the file location and macOS permissions; clear Locked in Get Info when you want to edit the file again. On Excel for the web, read-only access is usually determined by the file’s sharing permission. Open the workbook from OneDrive or SharePoint with view access, and ask the owner for edit permission if you need to make changes to the original.
Common Mistakes
- Double-clicking the file before choosing read-only. That opens it normally. Close it and reopen it through File > Open > Browse, then use the arrow beside Open.
- Assuming read-only means protected or private. Read-only is about limiting changes to the original file, not restricting who can see it. Anyone who can access the workbook may still be able to view or copy its contents.
- Confusing worksheet protection with read-only opening. Review > Protect Sheet limits certain edits to cells on a sheet. It does not use the same process as opening the entire file read-only, and sheet protection is not a replacement for secure file permissions.
- Clicking Enable Editing without considering the warning. If Excel opens a file in Protected View, that is a security precaution for a file Excel considers potentially unsafe. Protected View is not the same as the Open Read-Only choice. If you do not trust the source, do not enable editing or bypass the warning.
- Expecting the setting to block every way of making a copy. A read-only workbook may still be copied or saved under another name. The setting helps preserve the original; it does not stop someone from creating a separate file.
- Using a folder’s Read-only checkbox as if it locks every workbook inside. Folder attributes behave differently from a file’s Read-only attribute. Set the attribute on the specific workbook, or use sharing permissions to control access.
Tips
- Use Open Read-Only for a single review. It is the simplest choice when you only need to inspect a workbook once and do not want to change its ongoing settings.
- Save a separate copy for analysis. If you need to sort, filter, add notes, or test formulas, choose File > Save As and use a new filename. Keep the source file untouched and make clear which version contains your edits.
- Use sharing permissions for shared files. In OneDrive or SharePoint, view-only access is more dependable for controlling whether collaborators can edit the shared original. Ask the file owner to change your permission if the workbook opens with editing disabled.
- Check the file location. A local Windows file, a network drive, and a cloud workbook can behave differently. Excel’s opening option does not override a server’s access controls, an organization’s policy, or a cloud owner’s permissions.
- Keep an untouched source copy when changes matter. If the workbook is important, store a backup in a separate location before editing a working copy. Read-only mode reduces accidental overwrites but is not a backup system.
Troubleshooting
There is no arrow next to Open. Make sure you used File > Open > Browse in Excel and selected a file once. The arrow is part of the Open button in the file dialog and can be small. If the option remains unavailable, your version or opening location may not offer it. Use the Windows file Read-only attribute or a view-only sharing permission instead.
The workbook opens normally even though you expected read-only. Close it without saving, then reopen it using the Browse dialog and explicitly select Open Read-Only. A workbook’s Always Open Read-Only recommendation is only a prompt, so it may have been declined earlier. Also check whether you opened a shortcut or a different copy of the workbook.
Excel says the file is locked or in use. Another person may have the workbook open, or Excel may still have a stale lock after an unexpected close. If you only need to view it, choose the read-only option if offered. Do not delete temporary lock files while another person may still be editing. If you need to edit, ask collaborators to close the workbook or contact the file owner or administrator.
You cannot save your edits. That is expected when you opened the original read-only or lack edit permission. Use File > Save As to create a separate copy if you are allowed to do so. If you need to update the shared original, ask for edit access rather than trying to bypass its permissions.
The file stays read-only after you change its Windows setting. Close every Excel window using that workbook, check the file’s Properties again, and confirm the Read-only box is cleared. If it is stored on a network, in OneDrive, or in SharePoint, the location’s permissions may still prevent editing. A file marked as locked in Finder on a Mac also needs to be unlocked in File > Get Info.
Protected View appears instead of a read-only prompt. Protected View is a separate safety feature, often used for files from the internet or other potentially unsafe locations. If you trust the source, verify it with the sender or your organization’s security guidance before enabling editing. If you do not trust it, leave it in Protected View and close it.
Frequently Asked Questions
Can I open Excel itself in read-only mode?
Read-only applies to a workbook, not to the Excel application as a whole. Choose the read-only option for each workbook you want to inspect without saving changes over its original.
Can I still edit a workbook after opening it read-only?
You may be able to make temporary changes in the open session, but you generally cannot save those changes over the read-only original. Use Save As to create a separate copy, if permitted, or request edit access to the original.
Does read-only mode stop other people from editing the workbook?
No. Opening a workbook read-only affects your session. To limit other people’s ability to edit a shared original, use OneDrive, SharePoint, or other file-system permissions managed by the owner or administrator.
How do I remove read-only mode?
If you chose Open Read-Only just for that session, close the workbook and open it normally. If the Windows file attribute is set, clear Read-only in the file’s Properties. If Finder shows the file as Locked, clear that setting in Get Info. For a shared file, ask its owner to grant edit permission.
Will opening a workbook read-only change its formulas or formatting?
No. Merely opening the workbook read-only does not change its saved formulas or formatting. Any edits made during the session are not written over the original unless you save a writable copy or the file’s permissions allow a save.
Related
- Excel Share Mode: How to Keep Your Workbook Shared
- Excel Insert Row Shortcut: Steps for Windows and Mac
- How to Insert Multiple Images in an Excel Cell: Guide
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Insert a Signature in Word on Windows and MacTo insert a signature in Word, add a picture of your handwritten signature, draw one with Word’s ink…
- Examples of Ratings in Excel: Scores, Stars, and RulesExamples of ratings in Excel include 1-to-5 customer scores, star displays, letter-grade categories, and color-coded performance scales. For…
- Excel Color Based on Value with Conditional FormattingTo set color in Excel based on a value, select the cells, then choose Home > Conditional Formatting…
- Google Wedding Budget Spreadsheet: Setup and TrackingA Google wedding budget spreadsheet is a Google Sheets file for listing estimated costs, vendor quotes, final prices,…
- Extract Email Addresses From Text in Excel 365 EasilyIn Microsoft 365 Excel, use REGEXEXTRACT to pull email addresses from a text cell: with the text in…
- Excel Shortcut to Switch Between Worksheet TabsIn Excel for Microsoft 365 on Windows, press Ctrl+Page Down to move to the next sheet tab, or…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.