What shared documents in Excel actually do

A shared Excel file lets multiple people open and edit the same spreadsheet at the same time. When you share a file, each person sees changes as they happen — or within a few seconds — without anyone having to email versions back and forth or manually merge edits. Excel tracks who made each change and when, so you can see the edit history if something goes wrong.

Shared documents work best for spreadsheets that need regular updates from a small group: a team budget, a project tracker, a sign-up sheet, or a shared inventory list. They work less well for files with complex formulas or macros, or when dozens of people are editing at once.

Key Takeaways

  • Shared Excel files must be stored in OneDrive, SharePoint, or Google Drive — not on your local computer or a USB drive.
  • You create a shared document by uploading your file to cloud storage, then sending the link to the people who need to edit it.
  • Each person needs to sign in with a Microsoft account (for OneDrive or SharePoint) or a Google account (for Google Drive) to edit together in real time.
  • You control who can view, edit, or share the file by changing the permission settings before you send the link.
  • Excel shows you who is currently editing and highlights the cells each person is working on, so you can avoid overwriting each other's changes.

Setting up a shared document with OneDrive

OneDrive is the easiest option if everyone on your team uses Microsoft accounts (which most people do, since they come with Outlook email). Start by opening your Excel file. Go to File in the top left, then click Save As. Choose OneDrive — Personal or OneDrive — [Your Organization] depending on whether this is a work file or personal file.

Pick a folder where you want to store the file, give it a clear name, and click Save. Once the file is on OneDrive, go back to File and look for a button that says Share (it may also say Share with a person icon). Click it. A panel will open on the right side of your screen.

In the share panel, you will see a box that says Add people or Invite people. Type the email address of each person you want to share with, separated by semicolons if there are multiple people. Below that, you will see a dropdown menu — make sure it says Can edit so they can make changes. If you only want them to view the file without editing, choose Can view instead. Click Share or Send.

Each person you invited will get an email with a link to the file. When they click the link and sign in with their Microsoft account, the file will open in Excel Online (the web version) or their desktop Excel app, and they can start editing immediately.

Sharing through SharePoint if you have a work account

If your organization uses Microsoft 365 for work, your files may need to live in SharePoint instead of OneDrive. SharePoint is a shared workspace where teams store documents together. The process is almost identical to OneDrive, but you upload to a SharePoint site instead.

Open your file, go to File and Save As, then look for your organization's SharePoint site in the list. It will usually be named something like "[Company Name] — [Department]" or just show your organization's name. Select the site and the folder where you want to save, name your file, and click Save.

Once it is saved, use the Share button the same way you would with OneDrive. Your organization may have set up default permissions, so check what access level each person gets before you send the link. If your organization requires it, you may also need to ask a SharePoint administrator to add people to the site before they can access files there.

Using Google Drive if your team prefers Google Sheets

If your team uses Google accounts instead of Microsoft accounts, you can upload your Excel file to Google Drive and convert it to Google Sheets, which has built-in real-time collaboration. Open Google Drive in your web browser, click the New button on the left, and choose File upload. Select your Excel file from your computer.

Once the file uploads, right-click it and select Open with, then choose Google Sheets. Google will convert the file — most formatting and formulas will transfer, though some complex Excel features may not work exactly the same way. Give the file a clear name by clicking the title at the top.

Click the Share button in the top right. Type the email addresses of the people you want to share with, choose whether they can Edit, Comment, or View, and click Share. They will get an email with a link and can start editing as soon as they click it and sign in with their Google account.

Managing permissions and controlling who can edit

After you share a file, you can change who has access and what they can do. In OneDrive or SharePoint, open the file and click Share again. You will see a list of everyone the file is shared with. Click on a person's name to change their permission level from Can edit to Can view, or click the X next to their name to remove their access entirely.

In Google Drive, open the file, click Share, and you will see the same options. You can also change the link settings by clicking the dropdown that says Restricted or Anyone with the link. Restricted means only the people you invited can access it. Anyone with the link means anyone who has the link can open it, even if you did not invite them directly — use this only if you want the file to be widely available.

If you need to stop sharing entirely, look for an option that says Remove access or Stop sharing. This will prevent anyone from accessing the file through the shared link, though people who already have a copy downloaded to their computer can still open that copy.

What happens when multiple people edit at the same time

When two or more people have the file open and are editing, Excel shows you who is working on it. In the top right corner, you will see small circles or initials representing each person currently in the file. If someone is editing a cell, that cell will be highlighted with a colored border so you know not to edit it at the same time.

If you and another person try to edit the same cell at the same time, Excel will not let you overwrite their change. Instead, you will see a notification asking you to resolve the conflict — usually by accepting their version, keeping your version, or reviewing both. This is rare if people are working on different parts of the spreadsheet, which is why it helps to divide up tasks before you start.

Changes save automatically every few seconds, so you do not have to click Save manually. If the internet connection drops, Excel will save your changes locally and sync them back to the cloud when you reconnect. You can see the full history of who changed what by going to File and looking for Version history or See all versions.

Troubleshooting common sharing problems

If someone says they cannot open the file, the most common reason is that they are signed in with the wrong account. They may have multiple email addresses or accounts, and the file is shared with only one of them. Ask them to sign out completely and sign back in with the email address you sent the invitation to.

If the file opens in read-only mode and they cannot edit, check the permissions. Go back to the Share settings and make sure their permission is set to Can edit, not Can view. If it is already set to edit and they still cannot make changes, they may need to close the file and reopen it for the new permissions to take effect.

If changes are not showing up in real time, it usually means the internet connection is slow or unstable. Ask the person to close the file and reopen it. If that does not work, they can try opening the file in a web browser instead of the desktop app — sometimes the web version syncs faster.

If you accidentally shared the file with the wrong person, remove their access immediately through the Share settings. They will no longer be able to open the file, but they may have already seen or downloaded the data, so treat it as if they have it.

Frequently Asked Questions

Can I share an Excel file that is stored on my computer instead of in the cloud?

No. Files on your local computer or on a USB drive cannot be edited by multiple people at the same time. You must move the file to OneDrive, SharePoint, or Google Drive first. The easiest way is to use File > Save As and choose cloud storage instead of your computer.

What happens to my shared file if I delete it from OneDrive?

If you delete it, everyone loses access to it. The file goes to your OneDrive trash folder, where it stays for 93 days before being permanently deleted. If you delete it by mistake, you can restore it from trash within that time window. Other people cannot restore it themselves — only the person who owns the file can.

Can I share a file with someone who does not have a Microsoft or Google account?

Not directly. They need an account to sign in and edit. However, you can give them view-only access with a link that does not require signing in, depending on your organization's settings. Check your sharing options to see if Anyone with the link is available. If not, ask your IT department whether guest access is turned on.

How do I know if someone is currently editing the file?

Look at the top right corner of the file. You will see small circles or initials for each person who has the file open. Hover over them to see their name. If you want a detailed log of who edited what and when, go to File and select Version history or See all versions.

Can I share a file with edit access but prevent people from sharing it with others?

In OneDrive and SharePoint, you can set permissions so people can edit but cannot reshare. When you invite someone, look for an option that says Allow editing or similar, and make sure Allow resharing or Allow sharing is turned off. In Google Drive, this option is not available — anyone with edit access can reshare the file.