What a shared Excel doc actually is
A shared Excel document is a spreadsheet stored in the cloud — usually on Microsoft OneDrive, Google Drive, or SharePoint — that multiple people can open and edit at the same time. Unlike a file sitting on one person's computer, a shared doc updates when ready for everyone viewing it. When you type something, the other people in the document see it appear within seconds. There is no emailing versions back and forth, no "final_FINAL_v3" naming chaos, and no accidental overwrites.
The key difference from a regular Excel file is the storage location and the permissions. A regular Excel file lives on your computer or a USB drive. A shared Excel doc lives on a cloud service where you control who can see it and who can change it.
Key Takeaways
- Shared Excel docs live on OneDrive, Google Drive, or SharePoint, not on your computer, so multiple people can edit them at the same time.
- You create the doc first, then share it by sending a link or typing in the email addresses of the people who should have access.
- You choose whether people can edit the doc or only view it — editing access means they can change anything, viewing access means they can only read it.
- Changes save automatically and appear for everyone within a few seconds, so there is no "save and send" step.
- You can see who is editing the doc right now and what changes each person made by looking at the version history.
Creating a shared doc on Microsoft OneDrive
Open Excel on your computer or go to Office.com in your web browser. If you are using your computer, create a new blank workbook, then go to File > Save As. Choose OneDrive as the location, name your file, and click Save. If you are using Office.com, click the Excel icon, choose Blank workbook, and it saves to OneDrive automatically.
Once the file is on OneDrive, click the Share button in the top right corner. A window opens asking you to type in the email addresses of the people you want to share with. Type each person's email, then choose whether they can Edit or View Only. Click Share, and they will get an email with a link to the document. When they click the link, they can open it and start editing right away.
If you want to share with someone but do not know their email, you can also copy the link and send it to them however you want — text, email, Slack, whatever. Just make sure the link settings say "Anyone with the link can edit" or "Anyone with the link can view", depending on what you want them to do.
Creating a shared doc on Google Drive
Go to Google Drive in your web browser and click the Create button on the left side. Choose Google Sheets (Google's version of Excel), and a new blank spreadsheet opens. It saves automatically with a default name like "Untitled spreadsheet" — click the name at the top to rename it to something you will recognize.
Click the Share button in the top right corner. Type in the email addresses of the people you want to share with, one at a time. For each person, choose Editor if they should be able to change the spreadsheet, or Viewer if they should only be able to read it. Click Share, and they get an email with the link. They can open it when ready and start working.
Google Sheets works slightly differently from Excel — the formulas and formatting are similar but not identical, and some advanced Excel features do not exist in Google Sheets. If your team is already using Google Workspace (Google's business suite), Google Sheets is usually the simpler choice because everyone already has a Google account.
Controlling who can see and edit your shared doc
When you share a document, you decide what each person can do. Editor access means they can change anything — add rows, delete columns, modify formulas, change formatting. Viewer access means they can read the spreadsheet and read a copy, but they cannot make any changes to the original.
You can change someone's access level anytime. Open the Share menu, find their name, and click the dropdown next to their email to change them from Editor to Viewer or remove them entirely. You can also set the document to "Anyone with the link can view" or "Anyone with the link can edit" if you want to share it more widely without typing in individual emails — but be careful with this, because it means anyone who gets the link can access it.
If you want to stop sharing with someone, open the Share menu, find their name, and click the X next to it. They will no longer be able to open the document, though they can still see it in their email history.
What happens when multiple people edit at the same time
When two people are editing the same spreadsheet, you can see their cursor and their name in the top right corner. If person A is typing in cell B3 and person B is typing in cell D5, both changes happen at the same time and both are saved. The spreadsheet does not lock cells or prevent simultaneous editing — it just records all the changes.
If two people try to edit the exact same cell at the exact same time, the cloud service keeps both versions for a moment, then shows you a conflict. You choose which version to keep. This is rare in practice because people usually work in different parts of the spreadsheet.
Every change is timestamped and recorded in the version history. You can go back to any earlier version of the document if someone makes a mistake or deletes something important. In OneDrive, click File > Version History. In Google Sheets, click File > Version History on the left side. You can see who made each change and when, and you can restore an older version if you need to.
Moving a regular Excel file to shared storage
If you already have an Excel file on your computer and want to make it shared, you do not have to recreate it. Open the file, go to File > Save As, and choose OneDrive or SharePoint as the location. Give it a name and click Save. The file is now on the cloud and you can share it the same way you would share a new document.
If you are using Google Sheets, you can upload an Excel file directly. Go to Google Drive, click Create, choose File Upload, and select your Excel file. Once it uploads, right-click it and choose Open With > Google Sheets. Google Sheets converts it to its own format so you can share it and edit it online. The original Excel file stays on your computer unchanged.
Be aware that when you convert an Excel file to Google Sheets, some formatting and advanced features may not transfer perfectly. Test the converted file to make sure all your formulas and formatting look right before you share it with your team.
Troubleshooting common shared doc problems
If someone says they cannot open the shared document, check the Share settings. Make sure their email address is listed, or make sure the link is set to allow anyone with the link to view or edit. If they have the link but still cannot open it, ask them to sign out of their Microsoft or Google account and sign back in, then try the link again.
If changes are not showing up for someone, have them refresh the page or close and reopen the document. Cloud services sometimes take a few seconds to sync, especially on slow internet. If one person's changes are not appearing for anyone else, they may have lost their internet connection — their edits are saved locally on their device but have not uploaded yet.
If you see a message that the file is locked or in use, it usually means someone else is editing it. Wait a few seconds and try again. You do not need to ask them to close it first — shared documents are designed to handle multiple people at once.
Frequently Asked Questions
Can I share an Excel doc with someone who does not have an Excel subscription?
Yes. If you store it on OneDrive or SharePoint, they can open and edit it in the web version of Excel without paying for a subscription. If you use Google Sheets, they do not need any subscription at all — Google Sheets is free for anyone with a Google account. They just need the link and the permission level you set.
What happens if I delete a shared doc by accident?
On OneDrive and Google Drive, deleted files go to a trash or recycle bin for 30 days before they are permanently deleted. You can restore it during that time by opening the trash, finding the file, and clicking Restore. After 30 days, it is gone for good, but you may be able to recover it from a backup if your organization has one.
Can I see what changes each person made to the shared doc?
Yes. Both OneDrive and Google Sheets keep a complete version history that shows who changed what and when. In OneDrive, click File > Version History. In Google Sheets, click File > Version History. You can see each change highlighted and click on any earlier version to see what the document looked like at that time.
What if I want to stop sharing the doc but keep it for myself?
Remove everyone from the Share menu, or change the link settings to "Only people you have explicitly shared this with can access". The document stays on your OneDrive or Google Drive, but nobody else can see it anymore. You can still open it and edit it anytime.
Is a shared Excel doc safe from hackers?
Shared documents on OneDrive and Google Drive use encryption and are protected by the same security as your email account. If someone gets your password, they can access your shared docs, so use a strong password and turn on two-factor authentication. Do not share sensitive documents like financial records or passwords with people you do not trust, and do not use "Anyone with the link can edit" for confidential information.