What a Shared Document in Excel Actually Is

A shared document in Excel is a spreadsheet that multiple people can open and edit at the same time, with everyone's changes showing up when ready. Instead of emailing a file back and forth and losing track of which version is current, a shared document lives in one place — usually OneDrive or SharePoint — and everyone works on the same file simultaneously.

When you share an Excel file this way, you can see who is editing which cells, watch changes appear in real time, and avoid the mess of merging conflicting edits later. The file stays in one location, and permission controls let you decide who can view it, edit it, or just comment on it.

Key Takeaways

  • Shared Excel documents live on OneDrive or SharePoint, not on your computer, so everyone accesses the same current version.
  • You must save your file to OneDrive or SharePoint first — local files on your desktop cannot be shared this way.
  • Sharing happens through a Share button in Excel, where you enter email addresses and choose whether people can edit or only view.
  • Multiple people can edit the same spreadsheet at once, and you will see their changes appear in real time with their names attached.
  • You can stop sharing at any time by changing permissions, and people lose access when ready.

Save Your File to OneDrive or SharePoint First

Before you can share an Excel file, it must live on OneDrive or SharePoint, not on your computer's local drive. If your file is currently saved to your Desktop or Documents folder, you need to move it first.

Open the file in Excel. Click File in the top left, then click Save As. In the left sidebar, select OneDrive (if you have a personal Microsoft account) or SharePoint (if your workplace provides it). Choose a folder or create a new one, then click Save. Excel will now save all changes to that cloud location instead of your computer.

If you are unsure whether you have OneDrive, check your taskbar or system tray — you will see a cloud icon if it is installed. If you do not see it, you can sign up for a free Microsoft account at microsoft.com, which includes OneDrive storage.

Click Share and Enter the Email Addresses

Once your file is on OneDrive or SharePoint, the Share button appears in the top right corner of Excel. Click it, and a panel will open on the right side of your screen.

Type the email address of the person you want to share with into the text box that says "Enter an email address or name." You can add multiple people by typing each address and pressing Enter after each one. As you type, Excel may suggest names from your contacts — click the name to add them quickly.

Below the email box, you will see two options: Can edit and Can view. Choose Can edit if you want the person to make changes to the spreadsheet. Choose Can view if you only want them to see the data without making edits. After you select the permission level, click the Share button.

What Happens After You Share

Once you click Share, Excel sends an email to each person you added. The email contains a link to the spreadsheet and a message you can customize. They do not need to do anything special — they can click the link in the email and start editing when ready.

When someone opens the shared file, you will see their name appear in the top right corner of Excel, next to a small circle with their initials. If they are editing a cell, you will see their cursor move and their changes appear on your screen in real time. This happens without anyone needing to save or refresh.

If you want to stop sharing with someone, click the Share button again, find their name in the list, and click the three dots next to it. Select Remove access. They will lose the ability to open or edit the file when ready.

Managing Permissions and Viewing Who Has Access

The Share panel shows you everyone who currently has access to the file. Next to each person's name, you can see whether they can edit or only view. To change someone's permission level, click the dropdown next to their name and select a different option.

At the bottom of the Share panel, you will see a link that says Copy link. This creates a shareable link you can paste into an email or message instead of typing individual email addresses. When you click Copy link, you can choose whether the link allows editing or viewing only before you copy it.

If you want to see a full list of everyone with access, click Share and then look for Manage access at the bottom of the panel. This shows a complete history of who has access and when they were added.

What to Do If Someone Cannot Open the File

If someone says they cannot open the shared file, the most common reason is that they are trying to open it from an old email link or a different location. Ask them to check their email for the most recent share notification from you and click the link in that email.

If they still cannot open it, make sure they are signed into their Microsoft account. They can sign in at office.com or by opening Excel and clicking Sign in in the top right. If they do not have a Microsoft account, they can create one for free at microsoft.com.

Another possibility is that their permission level is set to Can view when they need to edit. Go back to the Share panel, find their name, and change the permission to Can edit.

The Difference Between Shared and Local Files

A shared file on OneDrive or SharePoint behaves differently from a file saved only on your computer. With a shared file, you do not need to email versions back and forth — everyone always sees the current version. Changes save automatically, so you do not have to remember to click Save. If two people edit different cells at the same time, Excel keeps both changes instead of one overwriting the other.

A local file — one saved only to your Desktop or Documents folder — can only be edited by one person at a time. If you email it to someone else, you now have two separate copies, and merging changes later becomes confusing. This is why shared files are better for teamwork, even if you are just sharing with one other person.

Frequently Asked Questions

Can I share a file that is already on my computer?

Not directly. You must move it to OneDrive or SharePoint first using Save As. Once it is there, the Share button will appear and you can share it with others.

What if I want to share with someone who does not have a Microsoft account?

They can still view and edit the file. When you share with their email address, they will receive an email with a link. They can click the link and work in the file without signing in, though some features may be limited. For full functionality, they can create a free Microsoft account.

Can I see what changes each person made?

Excel shows you who is currently editing and their cursor position in real time. For a detailed history of all past changes, click File, then Version history to see a list of saved versions with timestamps and the names of people who made changes.

What happens if two people try to edit the same cell at the same time?

Excel allows both edits. If you type in a cell at the same moment someone else does, you will see a notification asking you to review the conflicting changes. You can then choose which version to keep or merge them manually.

Can I share a file with someone outside my organization?

Yes. You can share with any email address, whether they work at your company or not. The permission controls work the same way — you choose whether they can edit or view only.