How to Allow Some Users to Edit and Others to View an Excel File
Question details
The user wants to share an Excel file and assign different access levels to different people, allowing some to edit the workbook and others to only view it.
- Product
- Microsoft Excel, OneDrive
- Device & OS
- not provided
- Scenario
- Collaborating on a shared workbook where certain team members need to update data, while external stakeholders or other members only need to read the data.
- Observed behavior
- Creating a general sharing link assigns the same permission level to everyone who clicks it, preventing granular control over individual user access.
Ensure your Excel workbook is saved to a cloud storage location like OneDrive or SharePoint, as individual permission management requires the file to be stored online.
Share with Specific People to Assign Individual Permissions
Instead of using a generic sharing link, use the Manage Access feature to explicitly invite users and assign either Edit or View permissions individually.
General sharing links apply the same rules to anyone who uses them. To differentiate access between team members, you must avoid generic links and share the file directly with specific email addresses.
Locate your Excel file in OneDrive, right-click on it, and select 'Manage Access' from the context menu. You can also click the 'Share' button in the top-right corner of the Excel desktop app.
Click the '+' (plus) icon or the primary 'Share' button to begin adding people individually.
Enter the email addresses of the users who need to modify the workbook. Click the permission dropdown next to the entry field, set it to 'Can edit', and send the invitation.
Repeat the sharing process for the read-only users. Enter their email addresses, change the permission dropdown to 'Can view', and click send.
Modify Permissions for Existing Users
If you have already shared the document, you can adjust the access level of any individual user from Edit to View at any time.
Easily Manage Collaborative Permissions with WPS Office
WPS Office offers robust cloud collaboration tools. By saving your spreadsheets to WPS Cloud, you can effortlessly share files and set granular view or edit permissions for different team members, all within a familiar and intuitive interface.
- 1. Open and Save to Cloud: Open your spreadsheet in WPS Office and ensure it is saved securely to WPS Cloud.
- 2. Click Share: Click the 'Share' button located in the top-right corner of the application window.
- 3. Specify Users: Choose the option to share with specific people and input their respective email addresses.
- 4. Define Access: Select 'Viewer' or 'Editor' from the dropdown menu for each person before sending out the sharing invites.
Frequently Asked Questions
Why can't I change permissions on my current generic sharing link?
A generic 'Anyone with the link' URL applies a single, universal permission level to everyone who clicks it. Once created, you cannot split permissions on that same link. To apply mixed access levels, you must share with specific individuals directly.
Can I use a password to allow some people to edit and others to view?
Yes, in Excel you can go to 'File' > 'Save As', click 'Tools', choose 'General Options', and set a 'Password to modify'. Users who have the password can edit the file, while those without it can only open the workbook in read-only mode.
Do users need a Microsoft account to be assigned specific permissions?
When sharing to specific individuals via OneDrive, recipients usually need to verify their identity. They can do this either by signing in with a Microsoft account or by entering a secure, one-time passcode sent directly to their email address.
