Transfer Ownership Of Worksheet

In Excel, you can transfer ownership of a worksheet by saving the file to a shared location, such as OneDrive or SharePoint, and then granting your colleague permission to edit the file.

Once your colleague has access to the file, they can save a copy of the worksheet to their own OneDrive or SharePoint account, effectively taking ownership of the file.

This is way too complicated and an easier way needs to be found. We are basically creating a new file. If we have a file shared with tons of people. This is a hassle.

In Excel, you can transfer ownership of a worksheet by saving the file to a shared location, such as OneDrive or SharePoint, and then granting your colleague permission to edit the file.

Once your colleague has access to the file, they can save a copy of the worksheet to their own OneDrive or SharePoint account, effectively taking ownership of the file.

This is way too complicated and an easier way needs to be found. We are basically creating a new file. If we have a file shared with tons of people. This is a hassle.

Agreed. Microsoft need to improve the feature in which we can transfer the ownership of the file without need to download and reupload the file.

Go to the RESTRICTED ACCESS bar (in yellow) at the top of the file. Click on the Change Permission... button.

When the permissions window opens, click on the More Options button. In the list of accesses, scroll down to the person who currently adds access. Click on that person's access status rating and a list option is available in the drop down. You can change the person to Full Control. Save the worksheet with the new access changes.

This is terrible! My organization made us move to Microsoft from Google. I am in Managment and have been promoted to a different department. I have 100’s of people who share Excel workbooks that I own and you are telling me that the only way someone else can be the owner is to make a copy in their one drive and then reshare to 100’s of people??? This is inefficient and ill thought out! You need to find a different way for organizations especially to change ownership between people.

In Excel, you can transfer ownership of a worksheet by saving the file to a shared location, such as OneDrive or SharePoint, and then granting your colleague permission to edit the file.

Once your colleague has access to the file, they can save a copy of the worksheet to their own OneDrive or SharePoint account, effectively taking ownership of the file.