The fastest way to share an Excel file depends on who needs it and whether they need to edit it
If you want someone else to see or work on your spreadsheet, Excel gives you three main paths: email the file directly, use OneDrive or SharePoint to let people open it from the cloud, or send a read-only copy if you only want them to look. The method you pick changes how people access the file, whether they can edit it, and whether you see their changes in real time.
For a one-time share with one or two people, email works fine. For ongoing collaboration where multiple people edit the same spreadsheet at the same time, cloud storage is faster and prevents the mess of multiple versions floating around. For sharing with someone outside your organization or when you want to protect your original, a read-only copy keeps your data safe.
Key Takeaways
- Emailing the file works for quick one-time shares, but creates multiple copies that can get out of sync if people edit different versions.
- OneDrive and SharePoint let multiple people edit the same file at once and see changes when ready, which is the standard for teamwork.
- You can set permissions so some people can only view the file while others can edit it, giving you control over who changes what.
- A read-only copy protects your original file when sharing with people you do not fully trust or when you want to prevent accidental changes.
Emailing the file directly to one or a few people
Open your Excel file, then go to File > Share (or File > Send in older versions). Click Email. Excel opens your default email program with the file already attached. Type the recipient's address, add a message if you want, and send.
This method works when you need to send the file once or twice and the people receiving it do not need to work on it at the same time. The downside: if two people edit the file and email you back their versions, you now have three different files with conflicting changes. You have to manually merge the changes, which is slow and error-prone. Email is also not ideal if the file is large, because email servers sometimes reject attachments over a certain size.
If you use Outlook, you can also right-click the file in File Explorer, choose Send to > Mail recipient, and skip opening Excel entirely.
Using OneDrive or SharePoint for real-time collaboration
Save your file to OneDrive (your personal cloud storage) or SharePoint (your organization's shared workspace). Then go to File > Share and click Share again. Type the email addresses of the people you want to see the file. Choose whether they can Edit or just View. Click Share.
Excel sends them a link. When they click it, the file opens in their browser or in their copy of Excel. If two people open the file at the same time, they both see changes the other person makes within seconds. Excel also keeps a version history, so if someone deletes something important, you can roll back to an earlier version without losing the whole file.
OneDrive is free with a Microsoft account and gives you 5 GB of storage. SharePoint is part of Microsoft 365 for business and gives your whole team a shared workspace. If your organization uses Microsoft 365, SharePoint is usually the better choice because it keeps files organized in one place and handles permissions more carefully.
Setting different permission levels for different people
When you share through OneDrive or SharePoint, you control what each person can do. Edit means they can open, change, and save the file. View means they can open it but cannot make changes. You can also set Edit for some people and View for others in the same share.
To change permissions after you have already shared: go to File > Share, find the person's name in the list, click the dropdown next to their name, and pick a new permission level. You can also remove someone entirely by clicking the X next to their name.
If you share a link instead of sending to specific people, you can choose whether anyone with the link can edit, view, or request access. This is useful when you do not know everyone's email address or when you want to let people outside your organization see the file.
Creating a read-only copy to protect your original
If you want to share a spreadsheet but prevent anyone from changing it, save a copy as read-only. Open the file, go to File > Info, click Protect Workbook, and choose Mark as Final. This tells Excel to open the file in read-only mode by default, though people can still choose to edit it if they want.
For stronger protection, go to File > Info > Protect Workbook > Encrypt with Password. Set a password. Now anyone who wants to edit the file has to type the password first. This is useful when you are sharing financial data, customer lists, or anything else you do not want changed by accident.
You can also restrict editing on specific cells or sheets. Go to Review > Protect Sheet (or Protect Workbook for the whole file), set a password if you want, and choose which actions people can do. For example, you can let people fill in a form but not change the formulas underneath.
Sharing through a shared folder or network drive
If your organization uses a shared network drive or a folder that multiple people can access, you can save your Excel file there instead of emailing it. Everyone with access to that folder sees the same file. When one person saves changes, the others see them the next time they open the file.
This works, but it is slower than OneDrive or SharePoint because Excel has to check the network drive every time someone opens the file. It also does not show real-time changes the way cloud storage does — if two people open the file at the same time and both make changes, the second person to save overwrites the first person's work. For this reason, network drives are best for files that one person works on at a time, not for active teamwork.
Troubleshooting common sharing problems
If someone says they cannot open the file you shared, check that you sent the link to the right email address and that they have permission to view it. If they have the link but still cannot open it, ask them to sign in with their Microsoft account — some files require that. If the file is very large (over 100 MB), it may time out when opening in a browser; have them read it instead.
If two people edited the file at the same time and changes got lost, check the version history. In OneDrive or SharePoint, click File > Info > Version history to see all saved versions and restore an earlier one. If you emailed the file and got back two edited copies, open both files side by side and manually copy the changes you want to keep into one master file.
If someone is editing the file and it is taking a long time, they may have it open but not saved. Ask them to save and close it, then you can open it. Excel will tell you if someone else has the file open and prevent you from saving over their work.
Frequently Asked Questions
Can multiple people edit an Excel file at the same time?
Yes, if the file is on OneDrive or SharePoint. Each person sees the other's changes within a few seconds. If the file is on a network drive or sent by email, only one person should edit it at a time, or changes will be lost.
What is the difference between OneDrive and SharePoint?
OneDrive is personal cloud storage for one person. SharePoint is shared workspace for teams. If you work alone, OneDrive is enough. If you work with others regularly, SharePoint keeps files organized and handles permissions better.
If I share a file, can I stop someone from seeing it later?
Yes. Go to File > Share, find their name, and click the X to remove them. They lose access when ready if you shared a link. If you emailed them the file, they keep the copy on their computer, but they cannot see new changes you make.
What happens if I delete a shared file?
If the file is on OneDrive or SharePoint, it goes to the recycle bin and you can restore it for 93 days. If you emailed it, the copy on their computer stays — deleting your version does not affect theirs. If you want to make sure they cannot see it anymore, use password protection or remove their access before deleting.
Can I share an Excel file with someone who does not have Excel?
Yes. They can open it in Excel Online (free, in a web browser) or in Google Sheets if you convert it. Excel Online has fewer features than the desktop version but works for viewing and basic editing. If they need the full desktop version, they need to buy or subscribe to Microsoft 365.