sodcalculator

10 Tech How-To

Fix Excel Cannot Access Read-Only Document

Guide 10-44575 · Updated · Step by step

If Excel refuses to open a file with an error like “Excel cannot access ‘filename.xlsx’ because it is a read-only document,” the file is usually locked by another process, has restricted permissions, or is stored in a location that blocks write access. This guide walks through the most common causes and fixes, from unlocking the file to changing folder permissions, so you can get back to editing quickly.

What You’ll Need

  • Access to the file’s location (local drive, network folder, or cloud sync folder)
  • Permission to modify file properties and folder settings (may require administrator rights)
  • If the file is shared, coordination with other users who might have it open

Step-by-Step

  1. Close any other instances of the file. Check if the file is open in another Excel window, on another device, or in a preview pane. Ask anyone you share the file with to close it. If you’re on Windows, press Ctrl+Alt+Delete and open Task Manager; under “Processes,” look for Microsoft Excel and end any instances that are not your current one (save your work first).
  2. Check if the file is marked as read-only in its properties. Right-click the file in File Explorer (Windows) or Finder (Mac), select Properties (Windows) or Get Info (Mac). Look for the Read-only checkbox. If it’s checked, uncheck it and click OK (or Apply). On Mac, you may need to change the permission from “Read only” to “Read & Write” in the Sharing & Permissions section.
  3. Clear the read-only attribute using Command Prompt (Windows only). If the checkbox is grayed out or the file is locked, open Command Prompt as administrator (search “cmd” in the Start menu, right-click and select “Run as administrator”). Type attrib -r "C:\path\to\file.xlsx" and press Enter. Replace the path with the actual file location. This removes the read-only attribute forcefully.
  4. Check file permissions. In the same Properties/Get Info window, go to the Security tab (Windows) or Sharing & Permissions (Mac). Ensure your user account has Full control or at least Modify permission. If not, click Edit and grant yourself the necessary rights. On a network drive, the server administrator may need to adjust permissions.
  5. Move the file to a different location. Copy the file to your local desktop or Documents folder and try opening it from there. This bypasses issues with network paths, cloud sync conflicts, or folder-level read-only settings.
  6. Disable Protected View (if the file is from the internet or another unsafe location). In Excel, go to File > Options > Trust Center > Trust Center Settings > Protected View. Uncheck all three options temporarily and try opening the file. Re-enable them after testing for security.
  7. Check if the file is syncing with OneDrive or SharePoint. If the file is in a cloud-synced folder, open the cloud app (e.g., OneDrive) and ensure it’s fully synced. Sometimes the file is temporarily locked during sync. Right-click the cloud icon in the system tray and select “Pause syncing” for a few minutes, then try again.
  8. Use Excel’s “Open and Repair” feature. Open Excel, go to File > Open, browse to the file, click once to select it, then click the dropdown arrow next to the Open button and choose Open and Repair. This can fix corruption that might cause the read-only error.
  9. Save a copy with a different name. If the file is locked by another process, try opening it in a different way: in Excel, go to File > Save As and save it as a new file (e.g., filename_copy.xlsx). This creates a new file without the lock.

Common Mistakes

  • Forgetting to check if the file is open on another device. If you share the file via OneDrive or a network, someone else might have it open, which locks it as read-only.
  • Changing permissions without admin rights. On many systems, you need to be an administrator to modify file permissions. If you’re not, ask your IT department.
  • Disabling Protected View permanently. This is a security risk; only disable it to test, and re-enable it immediately.
  • Overlooking the file’s location. If the file is in a folder that is itself marked read-only (e.g., a downloaded zip folder), the file inherits that attribute.

Tips

  • If the file is on a network drive, copy it to your local machine first, edit, then upload back. This avoids many network-related locks.
  • Use Excel’s Info tab (File > Info) to see if the file is marked as “Final” or “Read-Only Recommended.” If so, click Protect Workbook > Mark as Final to unmark it, or uncheck “Read-only recommended” in Save As options.
  • Keep a backup of the file before making any attribute changes, especially if you’re using command line tools.
  • If you’re using a shared computer, ensure no other user has the file open in a hidden session.

Troubleshooting

If the error persists after trying all steps, consider the following:

  • Check if the file is actually stored in a read-only location. Some external drives, USB sticks, or network shares are formatted as read-only. Try copying the file to your desktop and see if it opens.
  • Look for hidden lock files. Excel sometimes creates temporary lock files (starting with ~$) in the same folder. If you see a file like ~$filename.xlsx, delete it (make sure no one is using the file).
  • Run Excel as administrator (Windows). Right-click the Excel shortcut and select “Run as administrator.” This can bypass some permission restrictions, though it’s not a permanent fix.
  • Check if the file is corrupted. If you can open it in Google Sheets or LibreOffice, try saving it in a different format (e.g., .xls) and then back to .xlsx.
  • If the file is on a SharePoint or OneDrive site, check the version history. Sometimes a previous version is not read-only. Go to the online portal, right-click the file, and select “Version History” to restore an earlier version.
  • If all else fails, contact your IT support. They can check server-side permissions or group policies that might be forcing read-only mode.

Frequently Asked Questions

Why is my Excel file suddenly read-only?

The most common reasons are: the file is open in another program or device, the file attribute is set to read-only, the folder is read-only, or the file is marked as final. Check each of these in order.

How do I remove read-only from an Excel file without changing permissions?

You can try saving the file as a new name using File > Save As. This creates a new file without the read-only attribute. Alternatively, use the attrib -r command in Command Prompt.

Can I open a read-only Excel file in edit mode?

Yes, but you need to remove the read-only attribute. If the file is locked by another user, you can open it as read-only and then use “Save As” to create an editable copy.

What does “read-only” mean in Excel?

It means the file can be viewed but not modified. Excel will not allow you to save changes to the original file unless you use “Save As” to create a new file.

Why does Excel say “cannot access” even though the file is not read-only?

This can happen if the file is corrupted, the folder permissions are restrictive, or the file is locked by a background process. Try opening it with “Open and Repair” or copy it to a different location.

Does the read-only error happen on Mac too?

Yes, Mac users can see a similar error. The fix is similar: check file permissions in Get Info, ensure the file is not locked, and try copying it to a different folder.

Related

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →