How to Share Excel in Real Time and Co-Edit Safely

How-to basics · Updated November 20, 2026

To share an Excel workbook in real time, save it to OneDrive or SharePoint, select Share, give your collaborators permission to edit, and have everyone open the same cloud file. Excel for Microsoft 365 can then show coauthors’ changes as they work. You will need an internet connection, a Microsoft account or work account, and a workbook saved in a supported cloud location.

What You’ll Need

  • A cloud location: Use OneDrive, OneDrive for work or school, or a SharePoint Online document library that you can access. A workbook saved only on your computer or a USB drive cannot be co-edited through Excel’s cloud sharing.
  • A compatible workbook: Use a modern Excel file, preferably .xlsx. Older formats such as .xls can prevent coauthoring; convert a copy to .xlsx if needed. Keep a separate backup before changing a file format or restructuring a workbook.
  • Internet access and sign-in: Sign in to Excel with the Microsoft account that has access to the file. Collaborators also need permission and an internet connection to see live changes.
  • Current Excel or a browser: Microsoft 365 Excel for Windows is the focus here. Collaborators can also use Excel for the web. Excel for Mac has a similar Share workflow; save the file to OneDrive or SharePoint and use its Share button.

Step-by-Step

  1. Save the workbook to OneDrive or SharePoint. Open the workbook in Excel for Microsoft 365 on Windows. If it is stored locally, choose File > Save As, select a OneDrive location or a SharePoint library, and save it there. If the workbook is already in OneDrive or SharePoint, open that cloud copy rather than a downloaded duplicate. Check the file name or location in Excel to confirm you are working on the cloud version. For a work or school file, your organization may restrict which locations you can use.
  2. Make sure the cloud copy is ready to share. Wait for the save or sync indicator to finish. If AutoSave is available, switch it on near the top-left of the Excel window. AutoSave helps save changes to the cloud file, but it does not grant other people permission to open it. If Excel displays a compatibility or upload warning, resolve that first; otherwise, collaborators may not see the same current workbook. Close any extra copy of the file that you have open from a local folder so you do not accidentally edit the wrong version.
  3. Open the sharing controls. Select Share in the upper-right corner of Excel. If prompted, sign in. You can enter collaborators’ names or email addresses in the invitation box. Alternatively, open the link settings to create a link with a chosen level of access. Available link types depend on your account and organization: options may include specific people, people in your organization, or anyone with the link. If you do not see an option, your administrator may have disabled it.
  4. Choose who can do what. Before sending an invitation or copying a link, inspect the permission setting. Choose Can edit if recipients need to change cells, add data, or save their work in the shared workbook. Choose Can view if they only need to read it. For sensitive files, use a specific-people invitation rather than a broadly accessible link, and avoid granting edit access to people who only need to review results. Select Apply if the sharing panel asks you to confirm the link settings.
  5. Send the invitation or copy the link. To invite people directly, enter their email addresses, add an optional message, and select Send. To distribute a link yourself, select Copy link and share it through a suitable channel. Tell recipients whether they have edit or view access and which workbook to open. When they select the invitation or link, they may need to sign in or verify their identity, especially if you chose specific people. Do not forward a restricted link to someone who was not invited and expect it to grant them access.
  6. Ask everyone to open the shared cloud file. Collaborators can open it in Excel for the web or in a current Excel app that supports coauthoring. In the desktop app, they should sign in with the account that received permission. If a browser asks whether to open the desktop app, either option can work; the important point is that everyone is editing the same file in OneDrive or SharePoint, not separate downloads. Excel may show collaborators’ names, initials, or presence indicators as they join.
  7. Work together and check that changes are saving. Each editor can enter data or make other permitted changes. Updates usually appear for others shortly after they are made, though network speed and workbook complexity can affect how quickly they show. Look for the save or sync status before closing Excel. If two people change the same cell close together, Excel may show a conflict or require a decision; coordinate directly and check the cell’s final value rather than assuming both edits were combined.
  8. Review access when the work is done. If the file should no longer be editable by everyone, use Share or the file’s Manage access controls to change permissions or remove a link. In OneDrive or SharePoint, open the file’s sharing or access details and review who has access. Keep the cloud file as the shared source of truth, and tell collaborators if you later move it or create a replacement copy, since an old link may no longer point to the file they should use.

Common Mistakes

  • Sharing a local file instead of the cloud copy. Sending an email attachment or a file path from your computer creates separate copies, not a live shared workbook. Save the file to OneDrive or SharePoint, then share from that location.
  • Giving view access when editing is expected. Recipients can open the workbook but will not be able to change it. Reopen the Share settings and change their permission to Can edit if appropriate.
  • Using the wrong link setting. A link restricted to specific people may not work for a colleague who was not included. Conversely, an anyone link may expose the workbook more widely than intended. Check the audience before sending it.
  • Editing different copies. A downloaded attachment, a file in Downloads, and the cloud original can have the same name. Confirm the OneDrive or SharePoint location and avoid uploading a second copy unless you intentionally want a separate workbook.
  • Assuming every Excel feature behaves identically in every app. Excel for the web, Windows, and Mac can differ in available features or controls. If a collaborator cannot use a particular feature, ask them to open the file in a supported desktop version or consult your organization’s Microsoft 365 settings.
  • Expecting password protection to replace sharing permissions. Workbook or worksheet protection controls what users can change in parts of a file; it is not a substitute for controlling who can access the file. Set cloud access deliberately as well.

Tips

  • Agree on editing conventions. Before a group starts, decide which tabs or columns each person owns, how to flag completed entries, and whether anyone should avoid changing formulas or headings. A short message can prevent accidental overwrites.
  • Use a view-only link for broad review. If a group only needs to inspect figures, use Can view rather than Can edit. This reduces unintended changes while still allowing people with access to see the workbook.
  • Protect important work with version history. OneDrive and SharePoint keep versions according to the account’s settings. If someone overwrites information, open the file’s version history from its cloud location and review an earlier version before restoring anything. Check the displayed date and editor carefully; restoring can replace the current file contents.
  • Keep a clear master file. Give the workbook a recognizable name and share its cloud link instead of repeatedly emailing attachments. If you need a snapshot for a report, make a separate copy and label it as a snapshot so nobody mistakes it for the live workbook.
  • Coordinate major changes. Ordinary data entry is well suited to simultaneous editing. For substantial structural changes, such as deleting sheets, rearranging columns, or changing formulas used by others, tell collaborators first or arrange a short pause so their work is not disrupted.

Troubleshooting

  • The Share button is missing or unavailable. Confirm that you are signed in and that the workbook is saved to OneDrive or SharePoint. If it is a local file, save it to a cloud location first. In a managed work account, your administrator may limit sharing or external access; contact your Microsoft 365 administrator if the controls remain unavailable.
  • A recipient gets an access denied message. Check the Manage access details for the file and confirm the person’s email address and permission. If the link is restricted to specific people, make sure the recipient is signed in with the invited account. You can send a new invitation or update access, but do not switch to a public link unless that is acceptable for the workbook’s contents.
  • Changes are not appearing for other editors. First ask everyone to confirm they opened the same OneDrive or SharePoint file and are online. Check Excel’s save or sync status and resolve any upload error. Close and reopen the cloud copy if updates remain stuck. If one person is editing an attachment or offline copy, their changes will not automatically appear in the shared workbook.
  • Excel says the workbook is locked or cannot be coauthored. Check that it is not an older .xls file, that collaborators are using a supported, up-to-date Excel app or Excel for the web, and that the file has finished uploading. Some workbook features or account policies can limit simultaneous editing. Try opening the cloud copy in Excel for the web to see whether the problem is specific to the desktop app, and consult your administrator if the file is managed by an organization.
  • Someone changed or deleted the wrong information. Coordinate with the other editors before making more edits to the same area. Use Undo only if the action is still your most recent change and you understand what it will reverse; in a shared session, undoing can affect shared work. For a broader recovery, review version history in OneDrive or SharePoint and restore a suitable earlier version, or copy needed cells from that version into the current workbook.

Frequently Asked Questions

Can multiple people edit an Excel workbook at the same time?
Yes. Save the workbook to OneDrive or SharePoint, grant each person edit access, and have them open the same cloud file using a supported Excel app or Excel for the web.

Do collaborators need Microsoft 365?
They need access to the shared file and a compatible way to open it. Excel for the web is an option for browser-based editing, but access requirements and available features can depend on the account and organization.

Can I share Excel in real time without OneDrive?
For Excel’s cloud coauthoring, use OneDrive or SharePoint. A local file or ordinary email attachment does not provide the same shared, live workbook. Other file-sharing services may not support Excel coauthoring in the same way.

Can I let people view the workbook but not edit it?
Yes. In the Share panel, choose Can view when setting up the invitation or link, if that option is available. Review the audience setting too, since view-only access can still reveal sensitive information.

Does Excel save changes automatically?
When AutoSave is available and enabled for a workbook stored in OneDrive or SharePoint, Excel saves changes to the cloud as you work. Still check the save status before closing, especially if you see a connection or upload warning.

Can I stop sharing later?
Yes. Open the file’s sharing or Manage access controls in Excel, OneDrive, or SharePoint. Remove a person’s access or disable a link if those options are available to your account.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.