How to Share an Excel File for Multiple Users to Edit at the Same Time

The only reliable way to let multiple people edit an Excel file at the same time is to store it in OneDrive or SharePoint and share the link. Email attachments, network drives, and locally saved files all break co-authoring — you end up with multiple versions, merge conflicts, or locked files that only one person can edit at a time.

This guide walks through the correct setup, permission options, and common issues when sharing Excel for simultaneous editing.

Why co-authoring only works with OneDrive or SharePoint

When an Excel file is saved locally (on your computer or a traditional network drive), only one person can have it open with write access at a time. Everyone else gets a read-only copy, or a prompt saying the file is locked.

OneDrive and SharePoint solve this by:

• Storing the file in the cloud where all users connect to the same version
• Synchronizing each person's changes in real time (you can see other people's cursors and edits live)
• Handling conflict resolution automatically when two people edit the same cell at the same time

Bottom line: if you want true simultaneous editing, the file must be in OneDrive or SharePoint.

Method 1: share from OneDrive (best for individuals and small teams)

This is the simplest method if you already use Microsoft 365 personal or business.

Step 1: save the file to OneDrive

If your file is saved locally, move it to OneDrive first:

In Excel desktop:

1. Click File → Save As.
2. Select OneDrive (your personal or work OneDrive).
3. Choose a folder and save.

Alternatively, you can drag the file into the OneDrive folder on your computer (the cloud icon in File Explorer), and it will sync automatically.

Step 2: share the file

Once the file is in OneDrive:

1. Open the file in Excel desktop (the saved OneDrive version).
2. Click Share in the top-right corner of the ribbon.
3. A sharing panel opens. You have two options:

Option A: invite specific people by email

• Type the email addresses of people you want to share with.
• Choose their permission level: Can edit (they can change the file) or Can view (read-only).
• Add an optional message and click Send.

Option B: share a link

• Click Copy link.
• Choose who can access: Anyone with the link, People in your organization, or Specific people.
• Choose Can edit if they need to make changes.
• Copy and share the link via email, Teams, or any other channel.

Step 3: all editors open the file from the shared link or OneDrive

Each person should open the file from the OneDrive link, not from a locally downloaded copy. If someone downloads the file and edits the local copy, those changes will not sync automatically.

Method 2: share from SharePoint (best for teams and organizations)

SharePoint is better for team or department files because it offers finer permission control, version history, and integration with Microsoft Teams.

Step 1: upload the file to a SharePoint document library

1. Go to your SharePoint site (your IT team can give you the URL, or access it from the Microsoft 365 app launcher → SharePoint).
2. Navigate to the Documents library (or create a new folder for your project).
3. Click Upload → Files and select your Excel file.

Step 2: share from SharePoint

1. Hover over the file in the document library and click the ... (More options) menu.
2. Click Share.
3. Invite specific people, or generate a shareable link — same options as OneDrive.

Step 3: permission levels to know

For most co-editing scenarios, Can edit is what you want for all participants.

Method 3: use Excel Online for browser-based editing (no desktop app needed)

If some collaborators do not have Excel desktop installed, they can edit in Excel Online (the browser version). It works automatically when they open a OneDrive or SharePoint link.

Excel Online is slightly more limited than desktop Excel (some advanced formulas and features are view-only), but for most data entry, analysis, and collaboration, it works well.

How to open a file in Excel Online directly:

• From OneDrive or SharePoint, click the file name — it opens in Excel Online by default.
• To edit in desktop Excel instead, click Open in Desktop App from the Excel Online toolbar.

Both desktop Excel and Excel Online can co-author the same file simultaneously.

Seeing other people's edits in real time

When co-authoring is working correctly, you will see:

• Colored cursors showing where each person is working (each collaborator gets a different color)
• Their name appearing next to their cursor
• Changes appearing live as they type and save

If you do not see this, try:

• Ensure AutoSave is on (toggle in the top-left corner of Excel desktop — it must be on for co-authoring to work)
• Refresh the file (close and reopen from the OneDrive/SharePoint link)
• Ask the other person to ensure they are also editing from the cloud link, not a local copy

Setting up permissions: who should be able to do what

Before sharing, decide on access levels:

For a working document that everyone edits:

• Share with Can edit for all collaborators
• Consider whether external people (clients, contractors) need access, and if so, use a guest-accessible link with an expiry date

For a report or template you want people to read but not break:

• Share the final version with Can view for most people
• Keep Can edit only for the people who maintain the file

For a data entry form that feeds into your analysis:

• Consider using Microsoft Forms to collect input, which writes to a connected Excel sheet — this keeps the source data clean while letting many people submit responses

Common problems and how to fix them

"File is locked" or "read-only" message

If someone gets a "file is locked by another user" message, the file is probably stored locally or on a network drive, not in OneDrive/SharePoint. Move it to the cloud.

If the file IS in OneDrive but still shows as locked:

1. The previous user may have left the file open without AutoSave enabled. Ask them to close and reopen from OneDrive.
2. Delete the temporary lock file — look for a hidden file starting with ~$ in the same folder (e.g., ~$myfile.xlsx) and delete it.

Changes are not syncing in real time

• Ensure AutoSave is turned on for all collaborators (top-left toggle in Excel).
• Ensure all editors opened the file from the cloud link, not a downloaded copy.
• Check that OneDrive sync is running (look for the OneDrive cloud icon in the system tray — it should not show a sync error).

Merge conflict warning

If two people edit the exact same cell simultaneously, Excel shows a conflict dialog asking which version to keep. This is rare with normal use (different people tend to work in different areas) but can happen. The dialog lets you accept your change or the other person's change — read it carefully before deciding.

External users cannot open the link

If you shared a link with "People in your organization only" and are trying to share with an external person, change the link setting to "Anyone with the link" (or invite them specifically by email, which issues a guest invitation).

Tips for smooth real-time collaboration

• Name your ranges: if multiple people are filling in different sections, use named ranges (Formulas → Name Manager) so it is clear who is responsible for what area.
• Protect sheets or ranges: to prevent accidental edits to formulas or headers, use Review → Protect Sheet to lock specific cells while leaving the editable areas open.
• Use comments for communication: instead of emailing about the spreadsheet, use Excel's built-in Comments (right-click a cell → Comment) so discussion stays attached to the relevant cell.
• Version history: OneDrive and SharePoint automatically keep version history. If someone makes a mistake, go to File → Info → Version History to restore a previous version.
• Tell collaborators to use AutoSave: anyone who turns off AutoSave will create lag — their changes only sync when they manually save (Ctrl+S).

Google Sheets as an alternative

If your team includes people who prefer not to use Microsoft 365, Google Sheets is an alternative for real-time collaboration. It uses the same approach (cloud-stored file, shareable link, simultaneous editing) and tends to be simpler to set up for cross-organization sharing. The trade-off is reduced Excel compatibility for complex workbooks with advanced formulas, macros, or pivot tables.

For a detailed comparison: Excel vs Google Sheets: Collaboration Tips for 2026

Frequently Asked Questions

Can I share an Excel file from a USB drive or network folder for simultaneous editing? No. Traditional file shares and USB drives do not support real-time co-authoring. The file must be in OneDrive or SharePoint.

Does everyone need a Microsoft 365 subscription to co-edit? The file owner needs a Microsoft 365 subscription to store files in OneDrive/SharePoint. Collaborators can use Excel Online (free, browser-based) to edit without a paid subscription, as long as they have a Microsoft account.

Can I share an Excel file with someone outside my organization? Yes. When creating a share link, choose "Anyone with the link" and set the permission to "Can edit". For extra security, you can set a link expiry date or password.

How many people can edit an Excel file at the same time? Microsoft supports up to 50 simultaneous co-authors in Excel. For most teams this is more than enough.

What happens if two people edit the same cell at the same time? Excel shows a conflict resolution dialog, letting you choose which version to keep. In practice, good collaboration means different people work in different sections of the spreadsheet to avoid this.

How do I stop people from accidentally editing my formulas? Use Review → Protect Sheet to lock cells containing formulas. You can leave the data-entry cells unlocked while preventing changes to the formula cells.

Use AI to build better Excel spreadsheets, together

Once your spreadsheet is shared and multiple people are working in it, the next challenge is often the formulas and analysis. CoreGPT for Excel lets you describe what you need in plain English — "sum column B where column A equals Sales" — and get the exact formula instantly, without looking it up. It also helps with data analysis, column descriptions, and writing within the spreadsheet. Free, works inside Excel, no registration needed.

Try it: CoreGPT for Excel

Related reading:

• How to Use ChatGPT in Excel: A Complete Guide
• Excel vs Google Sheets: Collaboration Tips for 2026