Yes. Multiple people can edit the same Excel workbook at the same time when it is saved to OneDrive or SharePoint and shared with editing permission; this feature is called co-authoring. For most people, the simplest setup is a current version of Excel or Excel for the web, a Microsoft account or work account, and a cloud-stored workbook.
How Excel co-authoring works
Co-authoring lets several people work in one shared workbook instead of passing separate copies back and forth. Each person opens the same cloud file, and Excel sends changes to the service and other collaborators as they work. The workbook remains a single file with a shared edit history, rather than becoming a collection of emailed versions that someone must combine later.
In a compatible version of Excel, collaborators can often see who else is in the workbook and which cells they are working in. Changes normally appear quickly, though network speed, synchronization, and the version of Excel being used can affect how promptly updates show up. Co-authoring is not a guarantee that every change is instant or that every workbook feature works in every app.
This is different from placing a workbook in a shared network folder. A folder can make a file available to several people, but it does not automatically let them safely edit it at once. A desktop Excel file opened from a local drive or ordinary network location may be locked for other editors, or a second person may end up working on a separate copy. Use OneDrive or SharePoint for Microsoft’s current simultaneous-editing approach.
What you need before sharing
The workbook must be stored in OneDrive or SharePoint, and each collaborator needs permission to edit it. They also need an Excel version or browser that supports co-authoring, and they should sign in with an account that has access to the file. A standard .xlsx workbook is the simplest choice for broad compatibility. Modern Excel can co-author some macro-enabled workbooks too, but macros cannot run in Excel for the web, and workbook features can behave differently across apps.
For a work or school account, an organization’s Microsoft 365 settings may limit sharing with people outside the organization or disable certain sharing options. If a Share button or editing option is missing, the cause may be account permissions or an administrator’s policy rather than a problem with the workbook.
- Cloud location: OneDrive or a SharePoint document library, not just a local folder.
- Permission: Collaborators need Can edit access; view-only access does not allow changes.
- Compatible app: Use a current Microsoft 365 version of Excel or Excel for the web for the most dependable experience.
- Connectivity: Internet access is needed to synchronize changes with the shared file.
How to let several people edit a workbook
In Excel for Microsoft 365 on Windows, save the workbook to OneDrive or a SharePoint library. If it is currently stored on your computer, use File > Save As and choose a OneDrive or SharePoint location. Then select the Share button, enter the collaborators’ email addresses, check that the permission is set to allow editing, and send the invitation. Depending on your organization’s settings, you may instead be able to create a link with editing permission and send it yourself.
- Open the workbook and save it to OneDrive or SharePoint.
- Select Share and add the people who need access, or create an appropriate sharing link.
- Confirm that the recipients can edit, not merely view, the workbook.
- Ask collaborators to open the shared file and sign in if prompted.
- Keep AutoSave enabled in desktop Excel when the option is available, and check that the file shows it is saving.
Excel for the web can open a workbook from OneDrive or SharePoint and provides a Share option in its interface; the exact arrangement may look different from the Windows desktop ribbon. On Mac, the basic workflow is also to save the workbook to OneDrive or SharePoint and use Share. Button placement and some details can differ by Excel release, but the underlying requirement is the same: everyone must use the shared cloud file with edit access.
Tell collaborators to use the link to the shared workbook rather than downloading a copy and editing that. A downloaded copy is a separate file. Its changes will not automatically appear in the original, even if both files have the same name.
What collaborators can see and change
People with edit access can change workbook content, including values and formulas, subject to any worksheet or workbook protections in place. Co-authoring does not mean that each editor receives a private version of every cell. Most edits affect the same shared workbook, so a change to a shared input or formula can affect what every collaborator sees.
For example, a sales team might keep a shared table with one row per order. One person can enter new orders while another checks formulas or updates a separate section. Clear ownership of areas, consistent column headings, and a brief note about who is editing which section can reduce accidental overlap. If people need to sort or filter data independently, check whether the available Sheet View feature in their Excel version meets that need; changing a shared sort or filter can otherwise affect how the table appears to others.
Editing permission is not the same as permission to share the file with anyone. The owner or organization can restrict who can open the workbook and whether recipients can forward a sharing link. If the file contains sensitive information, review the link’s audience and access settings rather than assuming that every link is private to its intended recipient.
Limits across desktop Excel and Excel for the web
Excel for the web is useful for straightforward collaborative editing, but it does not provide every desktop Excel capability. Some advanced tools, file features, add-ins, and data connections may be unavailable or may require the desktop app. VBA macros cannot be run in Excel for the web. A workbook that relies on specialized features should be checked in the version people will actually use before a team depends on it.
Excel for Windows and Mac may also differ in available features, and users on older or unsupported releases can encounter compatibility issues. If someone opens the file in a version that cannot co-author it, Excel may ask them to use a supported version, open it read-only, or work in a way that does not synchronize as expected. Updating Excel and using a current browser are sensible first steps when collaborators do not see one another’s changes.
File format matters as well. A legacy .xls file is not the best starting point for current co-authoring. Save a copy in a modern format such as .xlsx when practical, then confirm that formulas, formatting, and other important workbook content remain correct. If the workbook contains macros, retain the macro-enabled format when needed and have desktop users verify that their required macro workflows still work.
Saving, offline work, and conflicting edits
With a cloud workbook, changes have to synchronize to OneDrive or SharePoint. In desktop Excel, AutoSave is generally available for files stored in supported cloud locations, but it may be unavailable or switched off in some situations. Look at the AutoSave control and the workbook’s saving status instead of assuming an edit has already reached everyone else. Excel for the web saves changes to the cloud as you work, but a connection interruption can still delay synchronization.
If someone loses internet access, the app may let them continue working locally or may limit what they can do. Do not assume that offline edits have been safely merged until the device reconnects and Excel reports that synchronization is complete. If a collaborator sees a warning, an upload problem, or a second copy created during recovery, stop making further edits to competing copies until the team identifies which file is authoritative.
When two people change the same cell close together, Excel may resolve the edits automatically, show a conflict, or leave one value in place over the other, depending on the situation. Do not treat co-authoring as a substitute for agreeing who owns a critical cell or reviewing important changes. For a key financial assumption, for example, assign one editor or record the intended change in a comment or team message before another person overwrites it.
OneDrive and SharePoint provide version history for supported files, which can help an authorized user inspect or restore an earlier version if a mistaken edit is discovered. Version history is a recovery aid, not a reason to skip backups or coordination for important work. For high-impact workbooks, agree on a review process and keep an appropriate backup before major structural changes.
Co-authoring compared with legacy shared workbooks
Excel has an older feature known as Shared Workbook, sometimes called the legacy shared workbook feature. It is not the same as modern cloud co-authoring. The legacy feature was designed for older file-sharing workflows and has restrictions; it is hidden in many current Excel installations and is generally not the best choice for a new shared workbook. Its availability and setup can depend on the Excel version and configuration.
For new collaboration, use OneDrive or SharePoint co-authoring. It is designed around a shared cloud file, account-based permissions, and current Excel apps. A shared network folder or legacy sharing setup may still exist in an organization, but it should not be confused with live cloud collaboration. If a team’s existing process depends on legacy behavior, check its compatibility and migration requirements before changing the file location or format.
Common problems and practical fixes
- The other person can only view the file: Reopen Share and check that the person or link has edit permission. Also make sure they opened the shared cloud copy, not a downloaded attachment.
- Changes are not appearing: Confirm that both people are online, signed in, and editing the same file. Check AutoSave or the saving indicator in desktop Excel, and allow time for synchronization.
- The workbook says it is locked: Check whether someone opened a different copy or is using an older Excel version. Close duplicate copies and have collaborators open the OneDrive or SharePoint link in a supported app.
- A feature does not work in the browser: Try Open in Desktop App if the feature requires desktop Excel. Confirm that all collaborators understand which app is the source of truth.
- Someone changed the wrong data: Review version history if available, then restore or re-enter the correct information carefully. Tell the other editors before restoring a version, since doing so can remove later valid work.
For a workbook used by many people, structure can prevent more problems than technical troubleshooting. Keep one purpose per sheet, use Excel tables for lists that grow, label input cells clearly, and avoid having several people edit the same small set of assumptions. Protecting cells can reduce accidental changes, but protection settings should be tested with co-authoring and should not be mistaken for a replacement for access control.
Frequently Asked Questions
Can multiple users edit an Excel file at the same time?
Yes. Save the workbook to OneDrive or SharePoint, give each person edit permission, and have them open the shared file in a co-authoring-capable version of Excel or Excel for the web.
Can two people edit the same Excel cell?
They can attempt to, but simultaneous edits to one cell can lead to a conflict or one value replacing another. For important cells, agree on one editor or communicate the intended change and verify the final value.
Can multiple people edit an Excel file without OneDrive?
Not using Microsoft’s standard modern co-authoring workflow. A network drive or emailed workbook can provide file access, but it does not offer the same cloud co-authoring behavior. A local or network copy may be locked or lead to separate versions.
Can users edit a shared Excel workbook in a browser?
Yes, Excel for the web supports collaborative editing for compatible workbooks stored in OneDrive or SharePoint. Some desktop features are unavailable in the browser, so users may need to open the file in desktop Excel for particular tasks.
How do I stop someone from editing the workbook?
Change that person’s sharing permission to view-only or remove their access using the file’s sharing controls. If access comes from a shared link, review or disable that link as well; changing one person’s direct permission may not remove access granted another way.
Related
- Conditional Formatting: Highlight Duplicates in Excel
- Data Validation Testing: Methods and Examples
- Data Validation Studio: Excel Rules, Setup, and Limits
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- When Was Excel Created? The 1985 Launch ExplainedMicrosoft Excel was created and first released in 1985, initially for Apple Macintosh computers. Its first Windows version…
- How to Enter a Page Break in Excel and Control PrintingTo enter a manual page break in Excel for Microsoft 365 on Windows, select the row below or…
- Switch Excel Cell References: F4 and Reference TypesTo switch a formula reference between relative, absolute, and mixed types in Excel for Microsoft 365 on Windows,…
- How to Delete an Unwanted Page in WordTo delete an unwanted page in Microsoft Word for Microsoft 365 on Windows, press Ctrl+G, type \page in…
- How to Set an Out of Office Reply in Microsoft OutlookTo set an out-of-office reply in Outlook, open Automatic Replies, turn them on, write your message, and—if available—choose…
- Google Sheets Text Dropdown: How to Add OneTo add a text dropdown in Google Sheets, select the cell or range, choose Insert > Dropdown, enter…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.