How to Restrict Access to Individual Excel Worksheets in OneDrive
Question details
The user needs to know whether individual Excel worksheets in OneDrive can have separate sharing permissions and how to work around the workbook-level restriction.
- Product
- Microsoft Excel and OneDrive
- Device & OS
- not provided
- Scenario
- The user manages a shared Excel workbook in OneDrive and needs different employees to have separate view or edit access to specific worksheets.
- Observed behavior
- Excel and OneDrive apply sharing permissions to the entire workbook; individual worksheet-level permissions cannot be configured.
Confirm which worksheets should be grouped under the same permission level and make sure you have edit access to the shared workbook in OneDrive before moving or copying sheets.
Split Excel worksheets into separate workbooks and share each OneDrive file
Use this method when different employees need separate view or edit permissions because OneDrive cannot apply sharing permissions to individual sheets.
OneDrive and Excel treat a workbook as a single sharing unit. Moving permission-specific worksheet groups into separate workbooks is the standard workaround: each file then receives its own sharing link and access list.
WPS Spreadsheets can perform the move or copy operation while preserving worksheet data, formulas, and formatting.
Launch WPS Office, click Menu > Open, and select the shared Excel file from your OneDrive folder or a local copy that has the same content.
At the bottom of the WPS Spreadsheets window, right-click the sheet tab that needs different permissions, then select Move or Copy from the context menu.
In the Move or Copy dialog, choose (new book) from the To book drop-down list, check Create a copy, and click OK. A new workbook opens with the copied sheet.
Save the new workbook as an Excel .xlsx file. Repeat the move or copy action for every sheet or group of sheets that should have different access.
Upload the new workbooks to OneDrive, select each file, click Share, and enter the employees who should access that specific workbook. Set Can edit or Can view separately for each file.
Protect a worksheet with a password in WPS Spreadsheets
Use this method when you only need to prevent editing, not when you need different employees to have different view permissions.
Use WPS Spreadsheets to Split and Share Excel Workbooks
Open your Excel workbook in WPS Spreadsheets, move or copy each worksheet into a new .xlsx file, then share each file separately in OneDrive. This creates clear workbook-level permissions without losing Excel formatting or formulas.
- 1. Open the Excel file in WPS Spreadsheets: Click Menu > Open and select the .xlsx workbook from your OneDrive-synced folder or download.
- 2. Move or copy each worksheet: Right-click the sheet tab, choose Move or Copy, select (new book), check Create a copy, and click OK.
- 3. Save each new workbook: Click Menu > Save As, choose Excel Workbook (*.xlsx), and name each file according to the employee group or permission level.
- 4. Upload the new workbooks to OneDrive: Open OneDrive in your browser, upload the .xlsx files, select a file, and click Share.
- 5. Set permissions per workbook: Enter employee emails for each file and choose Can edit or Can view. Repeat for every separate workbook.
Frequently Asked Questions
Can I set different OneDrive permissions for individual sheets in the same Excel workbook?
No. Excel and OneDrive sharing permissions are applied to the entire workbook. To have different permissions, split the relevant sheets into separate workbooks and share each workbook.
Will splitting sheets in WPS Spreadsheets break formulas or formatting?
No. The Move or Copy command with Create a copy preserves formulas, cell formatting, named ranges, and data in the copied sheet. Cross-sheet formulas that reference other worksheets may need to be checked.
Can I use password protection instead of restricting OneDrive access?
You can protect a worksheet in WPS Spreadsheets to restrict editing, but password protection does not give different employees different view permissions. Use separate workbooks for true user-level access control.
How do I share each new workbook with different employees in OneDrive?
Upload each workbook to OneDrive, select the file, choose Share, enter the employee's email, and set the permission to Can view or Can edit. Repeat for each group.
Do I need Microsoft Excel to split worksheets for OneDrive sharing?
No. WPS Spreadsheets opens and saves .xlsx files, so you can split worksheets and upload the new workbooks to OneDrive without a Microsoft 365 subscription.
