Excel Workbook Is Read Only? Causes, Fixes, and Options

How-to basics · Updated November 18, 2026

An Excel workbook is read-only when Excel lets you view it but prevents you from saving changes to the original file. The fix depends on the cause: check for an editing or permissions message, see whether someone else has the workbook open, and confirm that the file or its storage location allows you to edit.

What “read-only” means in Excel

Read-only is a description of your access to a particular copy of a workbook, not a kind of Excel file. You can usually open the workbook, inspect its sheets, and sometimes make temporary changes, but Excel will not let you overwrite that copy. It may offer to save your changes under a different name or in another location.

The phrase can also refer to several different restrictions that look similar but need different solutions. A workbook might be read-only because its file property is set, because your account has view-only access, or because Excel opened it in a safety mode. Separately, a protected worksheet can block changes to selected cells even though the workbook itself is editable. Identifying which restriction you have is more useful than repeatedly trying Save.

Check the message before changing anything

Look at the top of the Excel window and read any banner, dialog, or status message. A yellow Protected View banner, a notice that another user has the file open, and a prompt asking whether to open as read-only point to different causes. If you can edit some cells but not others, worksheet protection is more likely than a read-only file.

Try a small, reversible test in a blank cell, then choose File > Save. If Excel refuses to save, note the wording of the error and whether it offers Save As. Cancel the test without saving if you do not want to alter the workbook. Avoid changing protection, permissions, or file properties until you know what is preventing the edit; those settings can be intentional.

  • “Protected View” usually means Excel has opened a file cautiously because of where it came from.
  • “Locked for editing” often means another person or another Excel session is using the file.
  • “You don’t have permission” points to account, folder, or organization access rights.
  • Some cells cannot be changed may indicate sheet protection or locked cells.

Common causes and what they indicate

One common cause is a read-only file attribute or a folder permission that allows viewing but not writing. On Windows, a file copied from a shared drive, email attachment, or archive may have different properties from the original. The folder can also be read-only for your account even when the file’s own Read-only box is clear.

Another cause is a workbook opened with an “Open as Read-Only” choice. Some workbooks are configured to recommend read-only access, and a user may accept that prompt by mistake. A workbook can also be marked as final: this discourages editing but is not a strong security control, and a person with appropriate access can generally choose to edit anyway.

Files stored on OneDrive, SharePoint, or a company network introduce account and collaboration issues. You may have view rather than edit permission, be signed into the wrong work account, or have a sync or connection problem. If a colleague has the file open in a way that prevents simultaneous editing, Excel may ask you to open a read-only copy. A second Excel window or a session left open on another computer can also be involved.

Finally, Excel may be limiting editing because the workbook is in Protected View, has a password to modify, or has protected sheets. These are distinct features. Protected View is a safety precaution; a password to modify controls editing access; sheet protection restricts operations within a sheet. They should not be treated as interchangeable.

Fix a read-only file on Windows

Start with the least disruptive checks. If the workbook is yours and stored locally, close it and any other Excel windows using it, then reopen it. If a dialog asks whether to open read-only, choose the editable option only if you trust the source and intend to make changes. If the file is on a shared drive, ask whether another user is actively editing it before trying to work around the lock.

  1. Check the file attribute. Close the workbook. In File Explorer, right-click the file, choose Properties, and look under the General tab. If Read-only is selected, clear it, choose Apply, and reopen the workbook. If the option is unavailable or the restriction returns, the folder or organization’s permissions may be controlling access.
  2. Check the folder and account. Confirm that you can create or edit other files in the same location. For a work file, ask the owner or administrator for edit permission rather than copying it to bypass a policy.
  3. Resolve a stale lock. Ask the person named in the message whether the workbook is still open. They should save and close it normally. Do not delete temporary lock files or force-close someone else’s session unless your IT administrator confirms it is safe.
  4. Use Protected View carefully. If Excel shows an Enable Editing button, use it only when you trust the file and expected to receive it. A file from an unknown sender or an unexpected download should remain untrusted until its source is verified.

If the workbook is marked as final, check File > Info > Protect Workbook > Mark as Final. The setting can be toggled by someone authorized to edit, but it is a notice rather than a way to secure confidential information. For a password-to-modify prompt, you need the password or an editable copy from the owner; do not assume that changing the file extension removes the restriction.

Save a separate copy when the original cannot be edited

If Excel allows you to change the workbook but not overwrite the original, use File > Save As and save a copy in a folder where you have permission. Give it a clear name, such as “Budget review – working copy,” and confirm the file type remains appropriate, often Excel Workbook (*.xlsx). This preserves the source file and gives you an editable version to work on.

A copy is not always a complete solution. It may no longer update in the same shared location, and other people may continue editing the original. Links to other workbooks, macros in an .xlsm file, data connections, and collaboration history can also matter. Keep the original format when possible, and check that formulas, links, and required features still work before relying on the copy. If your goal is to contribute to a shared document, ask the owner to restore your edit permission or provide the correct shared link instead.

When the problem is worksheet or workbook protection

If only certain cells are unavailable, look for a protected-sheet message. In Excel for Microsoft 365 on Windows, open the Review tab and choose Unprotect Sheet. If a password is requested, you need the password from the person who protected the sheet. Protection is commonly used to prevent accidental edits to formulas while leaving input cells available; it does not necessarily encrypt the data or prevent someone from viewing it.

Workbook structure protection is different: it can prevent adding, deleting, moving, or renaming sheets. On the Review tab, choose Protect Workbook to inspect the structure-protection control; removing protection may require its password. Neither sheet nor structure protection is the same as the file being read-only. If the whole workbook cannot be saved, resolving one protected sheet may not solve a separate file or permission restriction.

Excel for Mac has corresponding protection controls, though the ribbon layout and wording can vary by release. If a file is stored in Finder, use Get Info to inspect its sharing and permissions; a user needs Read & Write access to edit it. In Excel for the web, whether you can edit is also governed by the file’s sharing permissions, and some desktop-only features may require opening the workbook in the desktop app.

Shared workbooks, OneDrive, and Excel for the web

For a cloud-stored workbook, first confirm that you are signed into the Microsoft account that was granted access. A link can open a file in view mode even if another account has edit rights. Ask the owner to check the sharing settings and grant you edit access, or send a link intended for editing. In a managed organization, an administrator may restrict sharing or editing.

When simultaneous editing is supported and everyone has suitable access, changes can be shared through OneDrive or SharePoint. If Excel reports that the file is locked or cannot sync, check your internet connection and the OneDrive sync status, then close duplicate copies of the workbook. Avoid making edits in several downloaded copies and later replacing the shared file: that can overwrite newer work. If you must work offline, agree on which copy is authoritative and reconcile changes before uploading it.

How to prevent read-only surprises

A few habits reduce the chance of encountering the problem again. Store working files in a location where your account has edit rights, use the correct organizational account, and open shared workbooks from their current OneDrive or SharePoint location rather than an old email attachment. Close the workbook when you are finished, especially on shared computers, so another person is less likely to encounter a stale editing lock.

  • Keep an untouched original before making major changes to a workbook.
  • Use a clearly named working copy when the owner intends the source file to remain unchanged.
  • Ask for edit access rather than trying to defeat a password or workplace restriction.
  • Before enabling editing on a downloaded file, verify that you expected it and trust its source.
  • For important shared work, confirm that your changes synced before closing Excel or disconnecting.

Frequently Asked Questions

Why is my Excel workbook read-only when I am the owner?
Ownership alone does not guarantee write access to every copy. The file may have a read-only attribute, be open in another Excel session, be in a folder with restrictive permissions, or be opened under a different Microsoft account. Check the warning message and the file’s location first.

How do I remove read-only in Excel?
There is no single switch for every cause. For a local Windows file, close it and check File Explorer > Properties > General for the Read-only attribute. For a cloud file, request edit permission; for Protected View, enable editing only if you trust the file. A password-protected restriction requires authorization from the owner.

Why can I edit the cells but not save the workbook?
Excel may let you make temporary changes to a read-only copy while preventing you from replacing the original. Use Save As to create a working copy if appropriate, or resolve the file lock, folder permission, or cloud access issue so you can save to the intended location.

Does read-only mean the workbook is protected by a password?
No. Read-only access can result from file attributes, permissions, a lock, or a read-only prompt without any password. Worksheet protection and a password to modify are separate controls, and a read-only state does not by itself mean the workbook’s contents are encrypted.

Can I make a read-only copy editable?
You can often save a separate copy if Excel permits it and you have permission to create files in the destination. That does not grant access to edit or replace the original. For a shared or company workbook, ask its owner or administrator for the correct level of access.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.