Sharing an Excel workbook effectively can be as simple as sending a link or as complex as managing change histories and conflicts between users, depending on the method used. In this article, I explain, in detail and without hesitation, how to save and share Excel workbooks with both modern co-authoring options and the classic shared workbook system, including its limits, change tracking, and how to revoke access when necessary. The idea is that you know exactly what to do, what to expect, and what can't be done in each scenario..
You'll see when it's best to edit from the browser with Excel for the web, how to send email invitations, which applications allow simultaneous editing, and what the Shared label in the title bar means. We'll also review the traditional shared workbook method, including its history, filters by who and when, conflict resolution, and the complete list of disabled features. This way you can choose the most appropriate path and avoid surprises with unsupported features or changes that overlap each other..
Save and share an Excel workbook for collaborative editing
The most straightforward way today is to share the file so others can open it from a link and edit it online or in the app. When you send the invitation, recipients receive an email with a link; clicking it opens the workbook in a browser using Excel for the Web. From there you can choose whether to edit directly in the browser or, if you prefer, open in the Excel application..
The flow is very simple: within the workbook itself, you'll see the Edit Workbook option and can choose Edit in Browser to work in Excel for the web or Edit in Excel to continue in the desktop app. In both cases, access is maintained, so that each user works on the same shared copy..
When sharing is active, Excel makes it clear: the Shared flag appears in the document title bar. It is a very useful visual signal to confirm that the file is open to modifications by more people..
First, make sure the file is saved somewhere accessible to everyone. This can be a shared drive or any location common to everyone who will be collaborating, such as OneDrive for storing and sharing files. If the book isn't in a place everyone can reach, the collaboration breaks down before it even starts..
Co-authoring: who can edit at once and how selections look
Co-authoring allows multiple people to edit the same workbook at the same time. This works with versions that support simultaneous editing, such as Excel for Android, Excel for iOS, Excel Mobile, and Excel included in a Microsoft 365 subscription. If someone doesn't use a supported app, they can always edit from the browser with Excel for the Web..
When co-authoring is active, the cursor or other people's selections are usually displayed in different colors. However, this display depends on the version: these colored selections are displayed when using Excel for Microsoft 365, Excel for the web, Excel for Android, Excel Mobile, or Excel for iOS. In the case of Excel for Microsoft 365, it is also convenient to have the Autosave activated so that everything is fluid and visible.
If at any point you don't see other people's selections, wait a few seconds. Sometimes it's a matter of latency. If it doesn't change, check which version each participant is using: those using older versions can't edit simultaneously and their selections won't appear, and if they're using Excel Mobile, their selections may not appear either. Still, other people's changes are usually reflected almost instantly on your screen..
Share a workbook as read-only with Excel for the web
There are times when you want others to view the workbook but not touch anything. That's why you have read-only mode when sharing from Excel for the web. With a couple of clicks you disable editing on the link you send.
The usual process is: go to File, choose Share, and then Share with others, or tap the Share button in the top right corner. Enter the email addresses of the people you want to share with. If you've used these addresses before, they'll be suggested as you type so you don't have to type them in full..
Before sending, open the link options and change the permission: in the setting that indicates anyone with the link can edit, uncheck the Allow editing box and apply the changes. You'll see the description change to indicate anyone with the link can view. When you're done, send the link and Excel for the web will notify the recipients by email..
Classic Book Sharing: What It Is and Why It Has So Many Limitations
Beyond modern co-authoring, there's the classic shared workbook method. It allows several people to open and modify a file at the same time and also saves a history of changes. Its big disadvantage is that it blocks a lot of Excel functions while the sharing lasts..
With this legacy system, the author can even define how long changes are retained in the history. Detailed information about each change is also logged: who made it, when, and what specific data was altered. All of this is useful for auditing, but you need to know the restrictions before enabling shared mode..
Prepare the file and its location
First, create or open the book you want to share, with the data that others will need, importing or exporting what is necessary according to the source of the data using import and export data. Save the file to a location accessible to others. In environments where the traditional method is used, a shared network folder is typically the best option; hosting it on a traditional web server isn't suitable. Without a common location there will be no way for others to open and edit the same file..
Activate classic sharing
To activate the shared workbook the traditional way, go to the Review tab and find the Share Workbook command in Excel. On the Edit tab, check the box that allows changes by multiple users at once. Accept, and Excel will prompt you to save; confirm. When enabled, the document title displays the Shared label to indicate that others can now access it..
Change History: What it saves and for how long
Excel automatically records changes as soon as the shared file is saved. This record includes the person who made each change, the date, and the content changed. It is a very valuable trace to check who touched what..
The default retention period is 30 days. You can increase or decrease this value using the advanced options in the shared workbook dialog box, indicating the number of days you want to retain. Keep in mind that changes older than this limit are permanently deleted from the log..
View, filter, and highlight changes
To inspect your changes, use the Track Changes button on the Review tab. There you can highlight what's changed and choose what you're interested in viewing. The tool allows you to filter by period, by person, and by cell range.
Common options include viewing all edits, viewing only edits made after a specific date, viewing edits by a specific user, or limiting the edits to a specific range. If you turn on on-screen highlighting, you can hover over it to get details of each change..
In addition to highlighting the sheet, you can list changes in a spreadsheet called History. This section contains columns with information about the type of action taken and details of any changes that failed. It is a practical report for audits or to keep a copy outside the book.
Update changes automatically
If you're interested in monitoring progress in real time, you can set the workbook to automatically update other users' changes at fixed intervals, even if you don't save manually. That way you always work with the most recent version that has been saved..
Resolving conflicts when two people exchange the same thing
In classic shared workbooks, if you save at the same time as someone else and both of you have modified the same cells, a conflict occurs. Excel displays a dialog box to decide which change to keep. The last user who tries to save is the one who receives that notice and must choose.
The options are to keep your current change, keep the other person's, accept all of yours, or accept all of theirs. It is a decision that should be made with context, reviewing the information shown in the dialogue itself..
There's an advanced setting that makes saved changes prevail without prompting, thus avoiding the conflict dialog box. If you enable it, Excel will resolve the conflicts in favor of the most recent change, and you'll be able to see how the conflicts were resolved in the history sheet, with action type flags and references to the rows where the changes were discarded. Use it with caution, because it automates a decision that can be delicate..
Stop sharing and what you lose
When you decide to close collaboration in a classic shared workbook, ask everyone else to save and close, because any unsaved work will be lost. It is a basic measure to avoid wasting minutes or hours of editing..
Then, return to the Excel workbook sharing dialog box, make sure only you appear in the list of users with the file open, and uncheck the box that allows multiple users to edit. If that box is locked, the sheet may be protected, so unprotect it first. Upon confirmation, the book is no longer shared and no longer allows simultaneous edits..
Important: When a workbook is unshared, the change history is deleted. If you need to keep track of this, print the history sheet or copy its contents to another workbook before disabling sharing. Once deleted, that record cannot be recovered..
Personal views in classic shared books
Excel saves a customized view of the workbook for each user, which includes the displayed sheet and zoom level. By default, this view also retains any applied filters and print settings, although you can indicate that you prefer to keep the original filters and print options. Thus, each person sees the book with their own configuration when opening it..
Blocked features in the classic shared workbook
The classic shared workbook method is considered legacy and severely limits what you can do while it's active. Many features, such as macros, become unavailable during that time. It is a good idea to know the list to avoid surprises in the middle of the job..
| Unsupported elements | Non-admitted actions |
|---|---|
| Create or insert tables | Insert or delete blocks of cells |
| Add or modify conditional formats | Delete spreadsheets |
| Define or change rules of data validation | Merge cells or unmerge them |
| Create or change graphics and dynamic graphics | Sort or filter by format |
| Insert or edit images or other objects | Use drawing tools |
| Insert or modify hyperlinks | Assign, change, or remove passwords |
| Create, adjust, or view scenarios | protect the check out leaves or the book |
| Insert automatic subtotals | Group or organize data in a schema |
| Building data tables | Write, record, modify, view or assign macros |
| Create or change pivot table reports | Modify or delete array formulas |
| Create or apply data segmentations | Add, rename, or delete XML mappings |
| Create or modify sparklines | Link cells to XML elements |
| Add or Change Excel Sheets Dialog 4 | Use the XML Source pane, your taskbar, or the XML commands on the Data menu |
| Add threaded comments | Entering data with a data form |
| Edit or delete threaded comments |
These restrictions explain why in many cases it is recommended to opt for co-authoring with current versions of Excel or for editing in the browser, which do not carry this feature lock. If you need any of the table features, avoid enabling the classic shared workbook..
Good practices for choosing the sharing method
If your priority is collaborating without sacrificing modern Excel features, opt for linked editing and co-authoring in supported apps or Excel for the web. It's more flexible and doesn't block tools like tables, slicers, or sparklines. This approach also displays other people's selections in color and works with AutoSave..
If you're looking for detailed tracking with an auditable history, the classic shared ledger may be a good fit, but it assumes the limitations noted above from the outset. Plan what elements you will need before activating it and define the retention period for the history..
In environments where you want to allow viewing without modification, share the workbook in read-only mode by disabling editing in the link settings. This way you control who sees the content without exposing it to unwanted changes..
Useful signs, messages and checks
Remember that when you activate classic sharing, Excel will prompt you to confirm with OK and will immediately save the file. You'll also see a visual indication of Shared in the title bar. If that check mark doesn't appear, check that you have actually enabled the correct sharing..
When you share a link in Excel for the web, recipients receive an email inviting them to open the workbook. When they click the link, they're taken to their browser and can choose whether to continue there or open the application with Edit in Excel. Providing these two routes gives flexibility depending on each person's device..
If someone can't co-edit and needs to see changes, the most compatible alternative is the browser. Excel for the web works well as a meeting point for teams with different devices. This way you avoid versions that don't support simultaneous editing or that don't show selections..
The best way to get the job done when sharing an Excel workbook is to understand what each method allows and what it sacrifices. With modern co-authoring, you get fluidity and compatibility with current features; with classic shared workbook, you gain detailed records but at the cost of blocking many tools; and with read-only mode, you control sharing without opening the door to modifications. Choose the approach that best fits your goal and your team's Excel versions. Share this tutorial and more people will be able to share an Excel workbook easily..