Permission & Access Issues

How to Change Workbook Ownership and Remove OneDrive Access in Excel

Tauseeq MagsiTauseeq Magsi Nov 13, 2026 868 views

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.
Before you start

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.

Solution 1Recommended

Remove OneDrive Access to an Excel Workbook

Use this when you need to revoke a team member's permission without deleting the workbook.

1
Open OneDrive in a web browser

Go to OneDrive in a web browser and sign in with the Microsoft account that manages the workbook.

2
Open workbook details

Locate the workbook, select the three-dot menu next to it, and choose Details.

3
Manage access

In the right pane, select Manage Access to see users and groups with permission.

4
Remove the user

Find the user or group you want to remove, select their current permission level, and choose Stop sharing or Remove access.

Remove OneDrive Access to an Excel Workbook
Access removed: The selected user will no longer be able to open or edit the workbook through the previous OneDrive link.
Free Microsoft Office alternative

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. 1. Download WPS Office: Download WPS Office from the official website and install it on your device.
  2. 2. Open your workbook: Open the existing Excel workbook in WPS Spreadsheet to continue editing with familiar tools.
  3. 3. Share under your own control: Use WPS Cloud or your own storage to share the workbook with your team under permissions you control.
Avoid OneDrive permission and ownership lockouts for shared Excel workbooksFull compatibility with Microsoft Excel .xlsx, .xls, and .csv filesFamiliar spreadsheet interface for easy migration from Microsoft ExcelFree to download and use for individuals and teams
microsoft office alternative - wps office

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.