OneDrive is a great tool, but it can be a bit difficult when it comes to finding what you’ve shared with whom, and whether you need to do some permission clean-up. By using the OneDrive Sharing Report, you can get all this information in an easy-to-read Excel spreadsheet. Here’s how that works…
Go into OneDrive in your browser, and click on the Options icon. That will give you the OneDrive Settings option:
In the More Settings section, select Run Sharing Report:
Select a folder in your OneDrive to store the Sharing Report. In this case, I chose the Collection Folder:
The process takes less than a minute, and you will then see the file in your selected OneDrive folder:
In the spreadsheet, you’ll see the path of each of your files, the file type, who you’ve shared the file with, and the level of access they have:
This is a great tool to do a periodic audit of your OneDrive sharing to make sure you’re not showing too much to too many people.