You need to share an Excel file with a colleague or client. Emailing the file creates multiple versions and can fill up inboxes. Sharing a link from OneDrive keeps everyone working on the same, single file. This article explains how to generate a shareable link and control what recipients can do with your Excel workbook.
Key Takeaways: Sharing Excel Files from OneDrive
- Share button in Excel ribbon: Opens the OneDrive sharing panel directly from your open workbook.
- People in your organization with the link: A permission setting that allows anyone inside your company to access the file if they have the link.
- Copy Link feature: Instantly creates a sharing link with your default permission settings without opening a dialog.
How OneDrive Link Sharing Works for Excel Files
When your Excel file is saved to OneDrive or SharePoint, you are not sending the file itself. Instead, you generate a web address that points to the file stored online. Anyone with the link and the correct permissions can open the file in Excel for the web or the desktop app. The main benefit is real-time co-authoring, where multiple people can edit the spreadsheet simultaneously. You must save your file to OneDrive first. If you are working on a file from your local PC, use File > Save As and choose your OneDrive folder.
Understanding Permission Levels
OneDrive offers several permission levels for shared links. Can view allows recipients to see the file but not edit it. Can edit lets recipients make changes, add comments, and potentially delete content. The Specific people option requires recipients to sign in with an approved email address, providing the most control. The Anyone with the link setting creates a link that works without any sign-in, which is useful for public sharing but less secure.
Steps to Create a Shareable Link from Excel
The easiest method is to start from within the Excel application while your file is open. Ensure your file is saved to OneDrive, indicated by your user name and Autosave being On in the top-left corner of the window.
- Click the Share button
In the top-right corner of the Excel window, click the green Share button. This opens the Send Link panel on the right side of your screen. - Set link permissions
Click the dropdown menu that typically says “People in your organization with the link can edit.” Choose from: Anyone with the link, People in your organization, or Specific people. Then select either Can edit or Can view from the adjacent dropdown. - Apply settings and copy the link
Click Apply. A link will be generated in the “Copy Link” section. Click the Copy button to the right of the link. The link is now on your clipboard, ready to be pasted into an email, chat, or document.
Creating a Link from the OneDrive Website
You can also share a file without opening Excel. Navigate to onedrive.live.com in your web browser and sign in. Find your Excel file in the file list. Hover over the file and click the circle checkmark to select it. A toolbar will appear at the top of the page. Click the Share option on this toolbar. Configure the permissions using the same dropdown menus and click Copy Link. You can then paste this link anywhere.
Common Mistakes and Limitations to Avoid
Recipients See “Access Denied” or a Sign-in Prompt
This usually happens when the link was created with the Specific people permission but the recipient’s email was not added. Go back to the Share panel, click the three dots next to the link, and select Manage access. Add the recipient’s email address and ensure the permission is set to Can edit or Can view. Also, check if the file is inside a private folder in your OneDrive that has restricted access.
People Cannot Edit the File Simultaneously
If recipients are opening the file in read-only mode, verify the link permission is set to Can edit, not Can view. Also, ensure they are clicking the Open in Browser or Open in App button from the link, not downloading a separate copy. The Excel desktop app must be signed in with a Microsoft account that has edit permissions for real-time co-authoring to work.
File is Too Large to Share
OneDrive has a file size limit for sharing and syncing. For consumer accounts, the limit is 100 GB per file. For Microsoft 365 work or school accounts, the limit is 250 GB. If your Excel file is near or exceeds this size, consider splitting the data across multiple workbooks or using Power Query to connect to the data source instead of embedding it all.
Link Permission Levels Compared
| Item | Anyone with the link | People in your organization | Specific people |
|---|---|---|---|
| Best for | Public, non-sensitive data | Internal team collaboration | Sharing with external clients or partners |
| Sign-in required | No | Yes, with company account | Yes, with specified email |
| Can forward link | Yes, anyone can share it | Yes, anyone inside the org can share it | Only added recipients can use it |
| Security level | Lowest | Medium | Highest |
You can now share any Excel file from OneDrive with a controlled link. Use the Share button in Excel for the fastest method. For more control over sharing, explore the Manage access menu to see who has the link and remove access. An advanced tip is to set an expiration date for sensitive links via the OneDrive website under Link settings.