How to Change Workbook Ownership and Remove OneDrive Access in Excel
Question details
The user needs to manage OneDrive permissions for an Excel workbook by removing team members' access and changing workbook ownership.
- Product
- Microsoft Excel workbook in OneDrive
- Device & OS
- not provided
- Scenario
- A workbook is shared with a team through OneDrive, and the owner needs to revoke access or transfer ownership to another person.
- Observed behavior
- The expected state is that only intended users retain access and the new owner has proper ownership controls.
Sign in to OneDrive in a web browser with a Microsoft account that has owner or admin rights to the workbook and its SharePoint or Microsoft 365 location.
Remove OneDrive Access to an Excel Workbook
Use this when you need to revoke a team member's permission without deleting the workbook.
Go to OneDrive in a web browser and sign in with the Microsoft account that manages the workbook.
Locate the workbook, select the three-dot menu next to it, and choose Details.
In the right pane, select Manage Access to see users and groups with permission.
Find the user or group you want to remove, select their current permission level, and choose Stop sharing or Remove access.

Transfer Workbook Ownership Through Microsoft 365 or SharePoint
Use this when the file owner needs to change, because managing access permissions alone does not transfer ownership.
Manage and Edit Excel Workbooks Without OneDrive Permission Headaches in WPS Office
WPS Office is a free, lightweight Office alternative that opens, edits, and saves Excel .xlsx files with a familiar spreadsheet interface. You can keep files local or use your own cloud storage to share them without OneDrive access controls.
- 1. Download WPS Office: Download WPS Office from the official website and install it on your device.
- 2. Open your workbook: Open the existing Excel workbook in WPS Spreadsheet to continue editing with familiar tools.
- 3. Share under your own control: Use WPS Cloud or your own storage to share the workbook with your team under permissions you control.

Frequently Asked Questions
Where is the Manage Access option for a OneDrive workbook?
Open OneDrive in a web browser, find the workbook, select the three-dot menu, choose Details, and then select Manage Access in the right pane.
Does removing a user from Manage Access change the workbook owner?
No. Removing access only changes who can open or edit the workbook. To change the owner, use the SharePoint or Microsoft 365 ownership controls for the location where the workbook is stored.
Can I transfer ownership of a OneDrive workbook without SharePoint?
Ownership is managed through SharePoint or Microsoft 365. If the workbook is stored in OneDrive for Business, use the associated SharePoint or Microsoft 365 document library controls. Personal OneDrive accounts have different sharing options.
Will users lose access immediately after I remove them in OneDrive?
Yes, after you remove a user or group in Manage Access, they should no longer be able to open the workbook through the previous OneDrive sharing link.
What is the difference between Edit, View, and Stop sharing in OneDrive?
Edit allows users to change the workbook, View allows read-only access, and Stop sharing removes a user's access entirely. Choose the permission level that matches what each team member should be allowed to do.




