every excel open read only

Question

when some share me excel file then in my excel showing read only whenever sender already given access to me for edit.

i reinstalled the office and repair the office.

also i reinstall the os win 11 25 h2. however i facing same issue please guide how to fix.

Answer 1

Hi @FMS Pune

Thanks to reaching out here.

• please check how you open the excel file. any attachments comes to thru mail, It's should be read-only format so, you changed the file it's not saved because its read-only format. so every time attachments came right click save as attachment option once you saved go to location and open the file and change or edit your excel file.
• suppose locally saved file also facing this issue. better goto file->saveas then try to edit or change the file. its should be work.
• additionally once saved your file. right click the file go to properties check the attribute section. suppose read-only options enabled or not. suppose enabled just remove the check box and click apply.
• suppose excel file in shared folder and someone accessing the file that time also file will be read-only mode. you not able to save.

Thanks.

Answer 2

Hi @FMS Pune,

I’ll be glad to help you look into this. To better understand the scenario and help narrow down the root cause, I’d like to clarify a few points with you: 

• Are these files being shared with you via OneDrive, SharePoint, Teams, or as email attachments?
• When you open the file, do you see any banner or message at the top? If possible, could you share a quick screenshot of that message?
• Are you able to edit Excel files that you created yourself, or is every file opening as read-only?
• Could you try opening the same file in Excel for the web and see if the issue happens there as well?
• Have you tried using Save As to save a copy locally, then opening that copy to check if it is still read-only?

Whenever you have a moment, please feel free to reply with the details above by leaving a comment under this post. They will help me better understand what’s happening in your environment and suggest the most suitable next steps for you.

Thank you again, and I’m looking forward to your update.

---

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.  

Answer 3

Several common causes can make every shared Excel file open as read-only even when edit access is granted. Work through these checks in order:

1. Check if the file is actually locked by another session

• If the file is stored in OneDrive or SharePoint, it may be locked by another user or by a previous crash.
• Close Excel on all devices where the account is signed in.
• Wait a few minutes for the server to release the lock, then try again.
• If someone else has it open, ask them to close it or check it in, or open the file as read-only until they finish. This behavior is described in “Excel file is locked for editing.”

2. Verify the file is not saved as read-only in Windows

• In File Explorer, right‑click the Excel file > Properties.
• On the General tab, make sure the Read-only attribute is not checked.
• Click OK and reopen the file.

3. Check for antivirus forcing read-only

• Some antivirus products open Office files as read-only for safety.
• Temporarily disable the antivirus (if allowed by company policy) or add Excel/Office as an exclusion according to the antivirus vendor’s instructions.
• Then reopen the shared file.

4. Confirm it is not opening in Protected View

• Files from email, the internet, or “unsafe” locations may open in Protected View and appear read-only.
• When the yellow bar appears at the top of Excel, select Enable Editing.
• If this happens for all such files, review Protected View settings as described in “What is Protected View?” (linked from the read-only article).

5. Check SharePoint/OneDrive library settings (if files are in Microsoft 365) If the files are in SharePoint or OneDrive for Business, the library configuration can force sync as read-only:

• If the document library has Check-out required, Validation columns/metadata, or Draft Item Security set to Only users who can edit or Only users who can approve items, synced copies will open read-only.
• Ask the SharePoint/OneDrive admin to review the library’s Versioning Settings and column/metadata configuration and adjust if necessary.

6. Confirm the account and license used to open the file

• Make sure Excel is activated and signed in with the same Microsoft 365 account that has edit permissions to the shared file.
• If the file is associated with an unlicensed or expired OneDrive account, it can open read-only.

7. Use Microsoft’s guided support if the issue persists

• Use the Excel guided support for “Why does my Excel file open read-only?” to run automated checks and fixes.

If all of the above are correct and every shared file still opens read-only, capture where the files are stored (SharePoint site/OneDrive path), the exact banner or message shown in Excel, and involve the Microsoft 365 admin to review library and permission settings plus any security policies that might be forcing read-only.

---

References:

• Why did my file open read-only?
• Why can’t I edit this file?
• SharePoint files open as read-only
• Excel file is locked for editing
• Troubleshooting and support
• Office 2016 files open as read-only unexpectedly