Fix Excel Opens Workbooks as Read-Only in Microsoft 365
Question details
Users are unable to save changes to Excel files because workbooks open in read-only mode, even when saved in trusted locations.
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Opening and attempting to save an existing Excel workbook on a new Windows computer.
- Observed behavior
- Excel forces the workbook into read-only mode, and Windows displays a prompt stating the user does not have administrator rights when attempting to save the file.
Verify that the workbook is not currently open on another device or locked by a different user on your network, as this will naturally trigger read-only mode.
Run Excel as an Administrator
Use administrator privileges to bypass security software or temporary permission restrictions that force files into read-only mode.
Often, overzealous antivirus software or restricted Windows account types prevent standard applications from modifying files, even in trusted directories. Launching Excel with elevated privileges helps determine if this is the root cause.
Find the Excel icon on your desktop. If you do not have a desktop shortcut, search for 'Excel' in the Windows Start menu, right-click it, and select 'Open file location'.
Right-click the Microsoft Excel shortcut and select 'Properties' from the context menu.
In the Properties window, click the 'Advanced' button under the Shortcut tab.
Check the box next to 'Run as administrator', click 'OK' to apply, and then reopen your workbook to see if you can now save changes.
Modify Windows Folder Permissions
Ensure your specific Windows user profile has 'Full Control' over the directory where the Excel files are saved.
Edit Spreadsheets Seamlessly with WPS Office
If Microsoft Excel continues to restrict your files with complex permission errors, consider switching to WPS Office. It is a lightweight, highly compatible alternative that makes editing and saving your spreadsheets hassle-free.
- 1. Download and install: Get the free WPS Office suite from the official website and complete the installation.
- 2. Open the restricted file: Right-click your existing Excel file, choose 'Open with', and select WPS Spreadsheets.
- 3. Edit and save freely: Make your necessary changes and save the workbook directly to your desired local folder without restrictive permission prompts.
Frequently Asked Questions
Why does Excel say my file is read-only when I am the computer administrator?
Even if your account has administrator status, Windows features like 'Controlled Folder Access' or third-party antivirus software might block specific applications like Excel from writing data to protected folders such as Documents or the C: drive root.
How do I turn off the read-only attribute on an Excel file permanently?
Right-click the specific Excel file, select 'Properties', and look at the 'General' tab. If the 'Read-only' attribute box is checked at the bottom, uncheck it, click 'Apply', and then click 'OK'.
Does Microsoft 365 activation status affect read-only mode?
Yes. If your Microsoft 365 subscription has expired or if the software is not properly activated on your new Windows computer, Excel will enter a Reduced Functionality Mode, forcing all documents to open as read-only.
