'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Change Excel File Access from Editing to Viewing Only
Question details
The user wants to learn how to modify access permissions for an Excel spreadsheet, specifically downgrading users from having editing rights to view-only access.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Managing file permissions and co-authoring access for a shared spreadsheet to secure data integrity.
- Observed behavior
- Users currently have edit access, and the goal is to successfully restrict their permissions to view-only or remove them entirely without breaking the file sharing setup.
Before changing access permissions, ensure you are the file owner or have administrative rights to manage the sharing settings for the Excel workbook.
Change Permissions via the Modern Sharing Interface
Use this method if your Excel file is stored on OneDrive or SharePoint and you are using modern co-authoring features.
Modern Excel versions (Office 365, Excel 2019+) use cloud-based sharing. You can manage access dynamically through the built-in share pane without disrupting active viewers.
Open your Excel workbook and click the 'Share' button located in the top-right corner of the Excel window.
In the sharing menu, click on the 'Manage Access' option, which is often represented by a three-dot icon or located at the bottom of the sharing dialog.
Locate the specific user in the list. Click on the dropdown menu next to their name (which likely says 'Can edit') and change it to 'Can view'. If you want to revoke their access entirely, select 'Remove direct access'.
Apply the changes. The user's permission will be updated immediately, preventing them from making any further edits.
Use Workbook Protection or File-System Permissions
Use this method if you are working with an offline local file, a network drive, or using the legacy shared-workbook feature.
Easily Protect and Share Spreadsheets with WPS Office
WPS Office offers robust file sharing and document protection features, allowing you to seamlessly share files with view-only or editing permissions, just like Microsoft Excel, but completely free.
- 1. Open the Spreadsheet: Launch WPS Office and open your spreadsheet file.
- 2. Click Share: Click the 'Share' button located in the top-right corner of the interface to open the sharing settings.
- 3. Adjust Link Permissions: In the sharing dialog, change the permission dropdown from 'Anyone with the link can edit' to 'Anyone with the link can view'.
- 4. Copy and Send: Click 'Copy Link' and distribute it to your team. They will now only be able to view the spreadsheet without altering your data.
Frequently Asked Questions
Can I lock specific cells instead of the entire Excel file?
Yes. Select the cells you want users to be able to edit, right-click, and choose 'Format Cells'. Go to the 'Protection' tab and uncheck 'Locked'. Next, go to the 'Review' tab on the ribbon and click 'Protect Sheet'. The unlocked cells will remain editable, while the rest of the sheet becomes view-only.
What happens if a user is actively editing when I change their permission to view-only?
If you are using modern cloud co-authoring and downgrade a user's permission while they are in the file, Excel will notify them that their permissions have changed. Any unsaved edits they were attempting to make will not be synchronized to the original file.
How do I remove someone entirely from a shared Excel file?
Open the 'Share' pane, click 'Manage Access', find the user's name, click the dropdown menu next to their current permission, and select 'Remove direct access' or 'Stop sharing'. This will revoke their ability to open the file entirely.
