To share an Excel workbook for live collaboration, save it to OneDrive or SharePoint Online, select the Share button, and invite people with view or edit permission. When collaborators open the cloud-stored file in a compatible version of Excel, they can work in it at the same time and see many changes as they happen.
What Excel workbook sharing means
Workbook sharing can mean two different things: modern co-authoring, or the older Shared Workbook feature. Most people looking to share a workbook today want co-authoring: one cloud-hosted file that invited people can open, edit, and save together. It avoids the repeated copies created when each person emails a separate attachment.
Co-authoring is not the same as sending a workbook to someone. An attachment gives the recipient a separate copy; their edits do not automatically appear in your original. With a shared cloud file, everyone works on the same stored workbook, subject to the permissions and access rules set by its owner.
The distinctions matter in practice. If a team is updating a project tracker, co-authoring lets different people add updates to the shared file. If each person needs an independent version for private analysis, sharing a copy may be more appropriate. Decide whether collaborators should edit the same data before choosing how to distribute the file.
How to share a workbook in Excel for Windows
For Excel for Microsoft 365 on Windows, use this basic process. Names and options in the sharing dialog can differ slightly according to the account, organization policy, and Excel build.
- Open the workbook and save it to OneDrive or SharePoint Online. In Excel, use File > Save As and choose the appropriate cloud location. For an existing local file, save a cloud copy before inviting collaborators.
- Wait for the file to finish saving. If the AutoSave switch is available, turn it on for the cloud file. AutoSave helps keep changes saved, but it is not a substitute for checking that the workbook is in the intended location.
- Select Share, usually at the upper-right of the Excel window.
- Choose whether to invite specific people or create a sharing link, if your account offers both. Review the link or recipient settings before sending it.
- Choose whether recipients can edit or only view. Enter names or email addresses when inviting specific people, add an optional message, and send the invitation or copy the link.
People can open a shared workbook in Excel for Microsoft 365 or Excel for the web, depending on their access and the workbook’s features. If someone cannot use the desktop app, opening the file in a browser may be a practical alternative. On a Mac, the Share button and cloud collaboration work similarly, although save-location dialogs and some ribbon details differ from Windows.
Choose the right access and link settings
Permission is the main control over what recipients can do. View access lets someone read the workbook without being able to save edits to the shared file. Edit access allows changes to the shared workbook. Give edit permission only to people who need to change the data, formulas, or layout.
A link can be convenient, but its reach depends on its settings. Depending on your Microsoft account and organization, options may include access for specific people, people in your organization, or anyone with the link. An administrator may disable some choices. A link intended for named recipients is generally easier to limit than a broadly usable link. Do not assume that a link is private merely because you sent it to one person; recipients may be able to forward some types of links.
- Use named-person access for confidential or business workbooks when available.
- Use view-only access for reference files, published reports, or templates that recipients should not edit.
- Check whether the link allows editing before copying or sending it.
- Remove access when a person no longer needs it, using the sharing or access-management controls available for the file in Excel, OneDrive, or SharePoint.
Sharing permissions apply to the file, not to a promise that particular cells are secret. Hiding a worksheet or protecting a sheet is not a way to keep sensitive information confidential from someone who can access the workbook. Keep information that a recipient should not see in a separate file with separate access.
What co-authors can do together
With a supported cloud file and compatible Excel apps, multiple people can edit the workbook concurrently. You may see collaborators’ presence or selected cells, and their saved changes can appear without everyone taking turns. The exact indicators depend on the app and connection. A collaborator’s name or colored selection is useful context, but it does not replace clear agreement about who owns a particular section or input.
Co-authoring is especially useful for shared lists, schedules, inventories, and project trackers. For example, one person can update delivery dates while another adds status notes. Use clear column headings, consistent data-entry rules, and a defined process for adding rows. These habits help prevent errors that are caused by people entering different kinds of information, even when the technology is working correctly.
Some tasks still need coordination. Avoid having several people redesign the same worksheet, change the same formula structure, or reorganize a table simultaneously. Agree on who is responsible for major layout or formula changes, and tell collaborators when you are making them. Also remember that shared editing does not guarantee that every Excel feature behaves identically in the desktop app and the browser.
Resolve conflicts and recover earlier versions
When two people change the same cell or make overlapping structural edits, Excel may need to reconcile those changes. Co-authoring reduces the need to merge separate copies, but it cannot determine which conflicting value is correct. If a warning or conflict prompt appears, read the choices carefully and confirm the intended result with the other editor when the data matters.
For a recent change, Excel for Microsoft 365 includes Review > Show Changes. The pane can help identify who changed cells and what changed, although its available history and detail can depend on the file and app. For a cloud-stored workbook, version history can provide earlier saved versions; depending on the interface, find it through the workbook name in the title bar or through File > Info > Version History. Review a previous version before restoring it, because restoration can replace newer work.
- If a change looks wrong, pause further edits and identify which cells or sheets are affected.
- Use Show Changes or version history where available to investigate, rather than guessing from memory.
- Before restoring a version, consider saving a separate copy of the current workbook so newer work is not lost.
- Tell collaborators about the correction so they do not re-enter the same mistaken value.
For important work, version history is a useful recovery option, not a complete backup strategy. A separate backup can protect against accidental deletion, account problems, or other situations that affect access to the cloud file.
Compatibility and workbook features
For the smoothest sharing, use a modern Excel workbook format such as .xlsx and current Excel apps. Excel for the web can open and edit many common workbooks, but some features or editing tasks may require the desktop app. If a recipient sees a message that a feature cannot be used in the browser, opening the file in desktop Excel may help; the recipient still needs appropriate permission and a compatible app.
Macro-enabled workbooks use the .xlsm format. Sharing access to such a file does not mean that macros are automatically safe to run. Recipients should follow their organization’s security rules and only enable macros when they trust the source and understand what the code does. Avoid assuming every workbook feature, add-in, or automation will work the same way for every collaborator.
Excel for the web and the desktop application can differ in available tools and in how advanced workbook features are handled. Mac users can co-author cloud-hosted files too, but ribbon placement and some dialogs differ. If a collaborator reports an issue, ask which Excel app and platform they are using, whether the file is fully synced, and what message appears. That information is more useful than simply resending the link.
Modern co-authoring versus Shared Workbook (Legacy)
The older Shared Workbook (Legacy) feature was designed to let multiple people edit a workbook stored in a shared network location. It is different from today’s OneDrive and SharePoint co-authoring, and it has limitations involving workbook features and editing. For typical current collaboration, Microsoft’s cloud-based sharing is the preferred approach.
The legacy command may not be visible on the ribbon. In Excel for Windows, an organization or user who specifically needs it may be able to add Share Workbook (Legacy) through File > Options > Quick Access Toolbar, choosing All Commands and then the legacy command. Its availability can depend on the Excel version and setup. Do not select it merely because it sounds like the modern Share button; first confirm that a legacy workflow is actually required.
Emailing copies is another alternative, but it creates a version-control problem: people can edit different copies and later struggle to decide which one is current. If collaborators need independent drafts, use clearly named copies and define who will combine them. If they need one live source of truth, cloud co-authoring is usually simpler.
Privacy, security, and practical safeguards
Before sharing, check the workbook for information that should not leave your control. This includes hidden sheets, old worksheets, comments, notes, external links, and data that may not be obvious in the visible report. Removing access to a file later does not undo information someone already copied, downloaded, or recorded.
Follow your organization’s rules for business or regulated data, and use the organization’s approved OneDrive or SharePoint location rather than a personal account when required. Protecting a worksheet can reduce accidental edits, but it is not a substitute for access control or encryption. Likewise, a password that restricts opening a file is not a replacement for carefully managing who receives a link.
Good sharing practice also includes explaining the workbook’s purpose and expected edits. Tell collaborators which cells they should update, whether formulas should be left alone, and when changes are due. A short instruction sheet or a clearly labeled input area can reduce accidental damage more effectively than relying on everyone to infer the workbook’s design.
Frequently Asked Questions
Can I share an Excel workbook for free?
Some personal Microsoft accounts include OneDrive storage and access to Excel for the web, but available features, storage, and editing options depend on the account. Work or school access may depend on the organization’s Microsoft 365 licensing and policies.
Can two people edit the same Excel workbook at the same time?
Yes, when the workbook is stored in OneDrive or SharePoint Online and both people use compatible Excel apps with the right access. If someone opens a separate downloaded copy, their changes will not automatically become edits to the shared cloud file.
How do I share an Excel file without allowing edits?
Use Share and set the recipient or link permission to view rather than edit, if that option is available. Check the setting before sending the link, because permissions offered can vary with account and organization controls.
Why can’t I see changes from another person?
Confirm that both people opened the same cloud-stored file, that the other person has saved their edits, and that the internet connection is working. Also check whether one person is editing a downloaded copy or using an app that does not support the change being made.
Can I stop sharing a workbook after sending a link?
Usually, you can manage the file’s access in Excel, OneDrive, or SharePoint and remove a person or revoke a link, subject to the controls available to your account. Revoking access prevents future access through that route, but it cannot retrieve copies or information already downloaded.
Related
- Data Validation Named Range in Excel: Setup and Fixes
- Data Validation Reference Table in Excel
- Remove Duplicates in Power Query: A Practical Guide
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Conditional Formatting to Highlight Blank CellsYes. In Excel for Microsoft 365 on Windows, select the range and choose Home > Conditional Formatting >…
- Excel Insert Row Shortcut on macOS: Keys and OptionsIn Excel for Mac, select the row where the new row should go, then press Control+Shift+= (the plus…
- Remove Spaces in an Excel Column: Step-by-StepTo remove every ordinary space from a column in Excel, select the column or range, press Ctrl+H, enter…
- Excel Reference Table in a Dropdown ListYes. In Excel for Microsoft 365 on Windows, turn the source data into an Excel Table, create a…
- Excel Data Validation Drop-Down Not Showing? FixesIf an Excel data validation drop-down is not showing, select the cell and check Data > Data Validation…
- How to Create a Bookmark Template in Word You Can ReuseTo create a reusable, printable bookmark template in Word, set up a page with bookmark-sized table cells, design…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.