How to Share an Excel File as View-Only While the Owner Can Edit
Question details
The user wants to share an Excel workbook stored in Microsoft Teams or SharePoint so that recipients can only view it, while the file owner retains full editing rights.
- Product
- Microsoft Excel, SharePoint, Teams
- Device & OS
- not provided
- Scenario
- Sharing an Excel workbook for reading without allowing unwanted modifications from recipients.
- Observed behavior
- The goal is to restrict recipients to view-only access, ensuring they do not unintentionally inherit edit permissions from other SharePoint groups or sharing links.
Ensure you have the necessary owner or administrator rights to the file in Microsoft Teams or SharePoint before attempting to modify its access permissions.
Set View-Only Permissions and Verify Access in SharePoint
Adjust the file's sharing settings to 'View' and use the 'Check Permissions' feature to ensure no overlapping edit rights exist for the users.
When sharing files in collaborative environments like Microsoft Teams or SharePoint, users might unintentionally inherit edit permissions from other group memberships. It is crucial to manually verify effective access to guarantee the file remains view-only for specific individuals.
Navigate to your SharePoint document library or the Microsoft Teams Files tab, and locate the Excel workbook you want to share.
Click on the three dots (More options) next to the file name and select 'Manage access' from the dropdown menu.
In the Manage Access panel, click on the three dots at the top right and select 'Advanced settings' (or scroll down to click 'Advanced') to open the detailed permissions page.
Click on 'Check Permissions' in the ribbon. Enter the name or email address of the user you shared the file with, then click 'Check Now' to verify their effective access levels.
If the user has edit permissions through another group, either adjust the group's settings or click 'Stop Inheriting Permissions' for this specific file, then assign them a strict 'Read' permission level.
Easily Share Spreadsheets as View-Only with WPS Office
WPS Office provides a built-in Cloud sharing feature that lets you instantly generate a view-only link for your spreadsheets. You retain full editing control while guaranteeing others can only read your data.
- 1. Open your Spreadsheet: Launch WPS Office and open the spreadsheet you want to share with others.
- 2. Click Share: Click the 'Share' button located in the top right corner of the application window to open the sharing panel.
- 3. Set Permissions to View Only: In the sharing dialog, adjust the permission dropdown to 'Anyone with the link can View'.
- 4. Copy and Send Link: Click 'Create Link' to generate the secure URL, then paste it into an email or messaging app to share with your recipients.
Frequently Asked Questions
Why can users still edit my Excel file when I shared it as view-only?
In environments like SharePoint or Microsoft Teams, users may belong to a team or site group that already has edit permissions for the entire folder. These overarching group permissions override specific view-only links. Use the SharePoint 'Check Permissions' tool to find and resolve overlapping access rights.
Can I stop a single Excel file from inheriting folder permissions?
Yes. In the SharePoint Advanced permissions settings for that specific file, you can click 'Stop Inheriting Permissions'. This detaches the file from the parent folder's security settings, allowing you to grant precise view-only access to users without affecting the rest of the directory.
Can users download a view-only Excel file?
By default, users with view-only access can still download an offline copy of the file. If you are using Microsoft 365 or OneDrive, you can toggle on 'Block download' when creating the view-only sharing link to prevent them from saving a local copy.
Will I be notified if the view-only file is opened?
If you are actively collaborating in Excel Online, you will see a profile icon appear in the top right corner when someone opens the file. However, explicit notifications for every view depend on your specific SharePoint alert configurations.
