A Microsoft file hosting and synchronization service.
The most important thing for me is that putting the shared file in his “My files” folder seems to take it out of your OneDrive. Don’t try doing it again, as moving the file is not the same as creating a link or adding a shared file.
Your friend would normally be able to edit that file without having to take possession or transferring the file from your OneDrive since your other friends are able to collaborate on Excel documents with you.
I Suggest to try these steps:
- Share folders and not files. Create a new folder in your OneDrive account, place a test Excel file in that folder, and share the folder with your friend having Can edit permission. Do not transfer your existing files to the folder before testing it out.
Have your friend access the folder from the Shared option of OneDrive.com and edit the test file without moving it.
If you need the shared folder to be visible in his My files folder, he should have the Add shortcut to My files option selected, not Move to. This is because the process of moving an item changes its permission settings or removes them from the original location.
If the test file still disappears from his Shared list, check your original file's Manage access settings and confirm that your friend still has permission.