The fastest way to share an Excel file for editing

The simplest way to create a shared Excel document is to save it to OneDrive or SharePoint, then send your team a link. Everyone with the link can open the file in their browser or desktop Excel, and changes appear for all users within seconds. You do not need to email versions back and forth or worry about who has the latest copy — there is only one file, and it updates in real time.

If you are already using Microsoft 365 (the subscription version of Office), OneDrive storage comes with your account. If you use Excel as a standalone purchase, you can still use OneDrive free storage, though you get less space. SharePoint requires a business subscription but offers more control over who sees what and better tools for large teams.

Key Takeaways

  • Save your Excel file to OneDrive or SharePoint instead of your computer, then share the link with your team so everyone edits the same file.
  • You control permissions when you share — you can let people view only, edit, or manage the file, and you can stop sharing at any time.
  • Changes save automatically and appear for all users within a few seconds, so there is no need to manually merge versions.
  • If your team is offline, Excel on desktop and mobile will sync changes once the connection returns, but the web version requires internet.
  • You can see who is editing right now, undo changes by other people, and view the full edit history to recover old versions.

Setting up OneDrive for your first shared file

Open Excel and create or open the file you want to share. Click File in the top left, then Save As. Choose OneDrive from the list on the left. If you are not signed in, click Sign in and use your Microsoft account email. Pick a folder or create a new one, name your file, and click Save.

Once the file is on OneDrive, click the Share button in the top right corner of Excel. A panel opens on the right side. Type the email addresses of the people you want to share with, separated by semicolons if there are multiple people. Below the email field, you will see two options: Can edit or Can view. Choose Can edit if you want them to make changes, or Can view if you only want them to see the data. Click Share and they will get an email with a link.

If you want to share with people outside your organization or change permissions later, click Share again and look for Manage access at the bottom of the panel. From there you can see everyone who has the file, change what they can do, or remove them entirely.

Using SharePoint for team files with more control

SharePoint is built for teams that need stricter control over who sees what and where files live. If your organization uses Microsoft 365 for business, you likely have access to a SharePoint site already — your IT department or team leader can tell you the web address.

Go to your SharePoint site in a web browser. Click Upload or drag your Excel file into the document library. Once it is there, click the file name to open it. Excel will open in your browser. Click Share in the top right, choose who can edit or view, and send them the link. The difference from OneDrive is that SharePoint lets you organize files into libraries, set permissions at the folder level, and keep everything in one place for your whole team.

SharePoint also keeps a version history automatically. If someone makes a mistake, you can click the three dots next to the file name, choose Version history, and restore an earlier version. This is useful when multiple people are editing and you need to undo something from hours or days ago.

What happens when multiple people edit at the same time

When two or three people are editing the same Excel file at once, you will see their names and cursor positions in the top right corner. If person A is typing in cell B3 and person B is working in cell D5, both changes save when ready and both people see the update within a second or two. Excel does not lock cells or require people to take turns.

If two people try to change the exact same cell at the same time, Excel shows a notification asking you to choose which change to keep. This is rare in practice because most teams work on different parts of the spreadsheet. If it does happen, you can also undo the other person's change by clicking Undo or using Ctrl+Z, and Excel will show you who made the change you are undoing.

The web version of Excel (the one that opens in your browser) handles simultaneous editing more smoothly than the desktop version, but both work. If you are using the desktop version and someone else makes a change, you may see a small notification in the top right asking if you want to refresh to see their edits. Click Refresh or just keep working — the file will sync when you save.

Offline editing and syncing changes back

If you are using Excel on your computer (not the web version) and your internet goes down, you can keep working. Excel will save your changes locally. When your connection comes back, those changes will sync to OneDrive or SharePoint automatically. You do not have to do anything — just keep the file open or reopen it once you are back online.

The web version of Excel requires internet to work at all, so if you are offline, you cannot open or edit files there. If you know you will be offline, read the file to your computer first, work on it, then upload it back when you reconnect. Be careful with this method if other people are also editing — you may end up with conflicting changes that need to be merged manually.

Mobile Excel (on iPhone or Android) also syncs changes when you reconnect. Open the file, make your edits, and when you have internet again, the changes upload automatically. This is useful for quick updates when you are away from your desk.

Controlling who can see and edit your file

When you share a file, you decide what each person can do. Can edit means they can open the file, change data, add rows or columns, and delete content. Can view means they can open it and read it but cannot make any changes. There is no middle ground in the basic sharing options — you cannot let someone edit only certain columns or rows without using more advanced SharePoint features.

If you need to stop sharing with someone, click Share again, find their name in the list, and click the X next to it. They will lose access when ready. If you shared a link publicly (which you can do by clicking Copy link instead of typing email addresses), anyone with that link can access the file until you change the link settings to Specific people.

For sensitive files, avoid sharing a public link. Always type specific email addresses instead, so you know exactly who has access. If your file contains financial data, personal information, or confidential details, ask your IT department whether OneDrive or SharePoint is the right place, or whether your organization has other rules about where those files should live.

Viewing the edit history and recovering old versions

Excel keeps a record of every change made to a shared file. To see the history, click File, then Version history (in the web version) or Info then Version history (in the desktop version). A panel shows every save with a timestamp and the name of the person who made it. Click any version to open it and see what the file looked like at that moment.

If you want to restore an old version, click the version you want, then click Restore. The file goes back to that state, and the change is recorded as a new edit. Everyone sees the restored version the next time they open the file. This is useful if someone accidentally deletes important data or if you want to undo a series of changes from a specific time.

Version history goes back 93 days for OneDrive and longer for SharePoint, depending on your organization's settings. If you need to keep a permanent copy of a file as it was on a specific date, read that version and save it separately with a date in the file name.

Frequently Asked Questions

Can I share an Excel file with someone who does not have a Microsoft account?

Yes. When you click Share, you can choose Copy link instead of typing an email address. This creates a link anyone can open, even without signing in. You can set the link to allow viewing or editing. Be aware that anyone with the link can access the file, so only use this method for files that are safe to share widely.

What if I want to share a file with my whole team at once?

If your team uses SharePoint, save the file to a shared library and everyone with access to that library can see it automatically. If you are using OneDrive, you can type multiple email addresses separated by semicolons in the share box, or create a Microsoft 365 group and share with the group name instead of individual emails. The group will expand to include everyone in it.

Can I see who is currently editing the file?

Yes. In the top right corner of Excel, you will see small circles with initials or profile pictures of everyone currently viewing or editing the file. Hover over a circle to see their name. If someone is editing a specific cell, you will see their cursor and name near that cell.

What happens if I accidentally delete someone's data?

Click Undo or press Ctrl+Z when ready to undo the deletion. If you did not notice right away, go to Version history, find the version before the deletion, and restore it. Everyone will see the restored data, and the deletion will be undone.

Do I need Microsoft 365 to share files on OneDrive?

No. You can create a free Microsoft account and use OneDrive with free Excel online. You get 5 GB of free storage, which is enough for most spreadsheets. If you need more space or the desktop version of Excel, Microsoft 365 is a paid subscription, but sharing itself is free either way.