How to Apply Always Open Read-Only to Multiple Excel Files
Question details
The user wants to configure the Always Open Read-Only setting for multiple Excel files or folders simultaneously, allowing users to view the files as read-only but still have the option to select Edit Anyway.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Managing file access permissions for a team where users need to be prompted to open workbooks as read-only by default, without strictly locking them out of editing.
- Observed behavior
- Excel does not have a built-in command to batch apply the Always Open Read-Only workbook-level setting to multiple files or folders at once.
Determine whether your users strictly need view-only access, or if they specifically require the prompt that allows them to select 'Edit Anyway' upon opening the file.
Enable Always Open Read-Only for Individual Files
Because Excel lacks a batch command for this specific prompt, you must configure the workbook-level setting one file at a time.
The Always Open Read-Only feature is a workbook-specific property. It is designed to act as a gentle reminder to prevent accidental edits, rather than a strict security measure.
To ensure users see the 'Edit Anyway' prompt, you must manually apply this setting to each individual Excel workbook.
Launch Microsoft Excel and open the specific file you want to configure.
Click on the File tab in the top-left corner of the ribbon, then select Info from the left sidebar.
Click the Protect Workbook button to open the drop-down menu.
Select Always Open Read-Only. Save the workbook to apply the changes.
Apply View-Only Permissions via OneDrive or SharePoint
If you do not need the 'Edit Anyway' option and simply want to prevent users from modifying multiple files, you can use folder-level permissions in cloud storage.
Try WPS Office for Efficient File Management
While Microsoft Excel lacks a batch feature for the 'Always Open Read-Only' prompt, WPS Office provides a lightweight, highly compatible, and user-friendly alternative for managing your spreadsheets, document permissions, and daily tasks.
Frequently Asked Questions
Can I make an entire folder 'Always Open Read-Only' with the Edit Anyway option?
No, the 'Always Open Read-Only' feature with the 'Edit Anyway' prompt is a workbook-level setting and must be applied to each Excel file individually. Folder-level protections will completely lock out editing capabilities.
How do I remove the Always Open Read-Only prompt from an Excel file?
To remove the prompt, open the Excel file, navigate to File > Info > Protect Workbook, and click 'Always Open Read-Only' again to toggle the setting off. Save the file to keep this change.
Why use 'Always Open Read-Only' instead of a standard password protection?
'Always Open Read-Only' acts as a gentle reminder to prevent accidental changes, but still allows users to click 'Edit Anyway' if they intentionally need to modify the document. Password protection completely blocks access or editing without the correct password.
