:Â "Shared Workbooks" is an older feature that allows you to collaborate on a workbook with multiple people. This feature has many limitations, and has been replaced by co-authoring. Excel co-authoring is available in Microsoft 365 Apps Excel desktop client and Excel for the Web for Microsoft 365 subscribers.Buy or try Microsoft 365
Enabling the Shared Workbook feature
-
Be certain that you want to use this method before continuing. Shared Workbooks have limitations, and one in particular is the inability to edit using Excel for the web. Therefore we highly recommend co-authoring, which is the replacement for Shared Workbooks.
-
Create a new workbook or open an existing workbook. Then place it on a network location. For example, put it on a location like \\server_name\folder_name. Don't put the file on OneDrive or SharePoint. If you prefer those locations for the file, co-author the workbook instead.
-
Click Review > Share Workbook.
Note that in newer versions of Excel, the Share Workbook button has been hidden. Here's how to unhide it.
-
On the Editing tab, select the Allow changes by more than one user ... check box.
-
On the Advanced tab, select the options that you want to use for tracking and updating changes, and then click OK.
-
If this is a new workbook, type a name in the File name box. Or, if this is an existing workbook, click OK to save the workbook.
-
If the workbook contains links to other workbooks or documents, verify the links and update any links that are broken.
-
Click File > Save.
-
When you're done, - Shared will appear at the top of the Excel window, next to the filename.
Additional information
Please be aware that Shared Workbooks is an older method of sharing. Therefore, many items and actions are not supported when this method is used. The table below is only a partial list of features not supported.
|
Unsupported items: |
Unsupported actions: |
|---|---|
|
Creating or inserting tables |
Inserting or deleting blocks of cells |
|
Adding or changing conditional formats |
Deleting worksheets |
|
Adding or changing data validation |
Merging cells or splitting merged cells |
|
Creating or changing charts or PivotChart reports |
Sorting or filtering by format |
|
Inserting or changing pictures or other objects |
Using drawing tools |
|
Inserting or changing hyperlinks |
Assigning, changing, or removing passwords |
|
Creating, changing, or viewing scenarios |
Protecting or unprotecting worksheets or the workbook |
|
Inserting automatic subtotals |
Grouping or outlining data |
|
Creating data tables |
Writing, recording, changing, viewing, or assigning macros |
|
Creating or changing PivotTable reports |
Changing or deleting array formulas |
|
Creating or applying slicers |
Adding, renaming, or deleting XML maps |
|
Creating or modifying sparklines |
Mapping cells to XML elements |
|
Adding or changing Microsoft Excel 4 dialog sheets |
Using the XML Source task pane, XML toolbar, or XML commands on the Data menu |
|
Using a data form to add new data |
|
|
Adding threaded comments |
Editing, or deleting threaded comments |
Before you disconnect users, make sure that they have completed their work on the workbook. If you remove active users, any unsaved work of theirs will be lost.
-
Click Review > Share Workbook.
Note that in newer versions of Excel, the Share Workbook button has been hidden. Here's how to unhide it.
-
On the Editing tab, in the Who has this workbook open now list, review the names of users.
-
Select the name of the user who you want to disconnect, and then click Remove User. Please note that although this action disconnects the user from the workbook, it does not prevent that user from editing the workbook again.
-
To delete any personal view settings of the removed user, click View > Custom Views and delete any other user views.
Before you turn off this feature, you might want to make a copy of the change history. First make sure that all other users have completed their work.
-
Click Review > Track Changes > Highlight Changes.
Note that in newer versions of Excel, the Track Changes button has been hidden. Here's how to unhide it.
-
In the When list, select All.
-
Clear the Who and Where check boxes.
-
Select the List changes on a new sheet check box, and then click OK.
-
Now you can either print the History worksheet, or you can copy the history and paste it into another workbook.
-
Click Review > Share Workbook.
Note that in newer versions of Excel, the Share Workbook button has been hidden. Here's how to unhide it.
-
On the Editing tab, make sure that you are the only person listed in the Who has this workbook open now list.
-
Clear the Allow changes by more than one user ... check box. If this check box is not available, you must first unprotect the workbook. Do the following:
-
Click OK to close the Share Workbook dialog box.
-
On the Review tab, in the Changes group, click Unprotect Shared Workbook.
-
If you are prompted, enter the password, and then click OK.
-
On the Review tab, in the Changes group, click Share Workbook.
-
On the Editing tab, clear the Allow changes by more than one user ... check box.
-
When you are prompted about the effects on other users, click Yes.
-
Enabling the Shared Workbook feature
-
Be certain that you want to use this method before continuing. Shared Workbooks have limitations, and therefore we highly recommend co-authoring, which is the replacement for Shared Workbooks.
-
Create a new workbook or open an existing workbook. Then place it on a network location. Don't put the file on OneDrive or SharePoint. If you prefer those locations for the file, co-author the workbook instead.
-
Click Review > Share Workbook.
-
On the Editing tab, select the Allow changes by more than one user ... check box.
-
On the Advanced tab, select the options that you want to use for tracking and updating changes, and then click OK.
-
If this is a new workbook, type a name in the Save As box. Or, if this is an existing workbook, click OK to save the workbook.
-
If the workbook contains links to other workbooks or documents, verify the links and update any links that are broken.
-
Click File > Save.
-
When you're done, - Shared will appear at the top of the Excel window, next to the filename.
Additional information
Please be aware that Shared Workbooks is an older method of sharing. Therefore, many items and actions are not supported when this method is used. The table below is only a partial list of features not supported.
|
Unsupported items: |
Unsupported actions: |
|---|---|
|
Creating or inserting tables |
Inserting or deleting blocks of cells |
|
Adding or changing conditional formats |
Deleting worksheets |
|
Adding or changing data validation |
Merging cells or splitting merged cells |
|
Creating or changing charts or PivotChart reports |
Sorting or filtering by format |
|
Inserting or changing pictures or other objects |
Using drawing tools |
|
Inserting or changing hyperlinks |
Assigning, changing, or removing passwords |
|
Creating, changing, or viewing scenarios |
Protecting or unprotecting worksheets or the workbook |
|
Inserting automatic subtotals |
Grouping or outlining data |
|
Creating data tables |
Writing, recording, changing, viewing, or assigning macros |
|
Creating or changing PivotTable reports |
Changing or deleting array formulas |
|
Creating or applying slicers |
Adding, renaming, or deleting XML maps |
|
Creating or modifying sparklines |
Mapping cells to XML elements |
|
Adding or changing Microsoft Excel 4 dialog sheets |
Using the XML Source task pane, XML toolbar, or XML commands on the Data menu |
|
Importing, refreshing, and exporting XML data |
Using a data form to add new data |
Before you disconnect users, make sure that they have completed their work on the workbook. If you remove active users, any unsaved work of theirs will be lost.
-
Click Review > Share Workbook.
-
On the Editing tab, in the Who has this workbook open now list, review the names of users.
-
Select the name of the user who you want to disconnect, and then click Remove User. Please note that although this action disconnects the user from the workbook, it does not prevent that user from editing the workbook again.
-
To delete any personal view settings of the removed user, click View > Custom Views and delete any other user views.
Before you turn off this feature, you might want to make a copy of the change history. First make sure that all other users have completed their work.
-
Click Review > Track Changes > Highlight Changes.
-
In the When list, select All.
-
Clear the Who and Where check boxes.
-
Select the List changes on a new sheet check box, and then click OK.
-
Now you can either print the History worksheet, or you can copy the history and paste it into another workbook.
-
Click Review > Share Workbook.
-
On the Editing tab, make sure that you are the only person listed in the Who has this workbook open now list.
-
Clear the Allow changes by more than one user ... check box. If this check box is not available, you must first unprotect the workbook. Do the following:
-
Click OK to close the Share Workbook dialog box.
-
On the Review tab, click Protect Workbook.
-
If you are prompted, enter the password, and then click OK.
-
On the Review tab, Share Workbook.
-
On the Editing tab, clear the Allow changes by more than one user ... check box.
-
Before you turn off this feature, you might want to make a copy of the change history. First make sure that all other users have completed their work.
-
Click Review > Track Changes > Highlight Changes.
-
In the When list, select All.
-
Clear the Who and Where check boxes.
-
Select the List changes on a new sheet check box, and then click OK.
-
Now you can either print the History worksheet, or you can copy the history and paste it into another workbook.
-
Click Review > Share Workbook.
-
On the Editing tab, make sure that you are the only person listed in the Who has this workbook open now list.
-
Clear the Allow changes by more than one user ... check box. If this check box is not available, you must first unprotect the workbook. Do the following:
-
Click OK to close the Share Workbook dialog box.
-
On the Review tab, click Protect Workbook.
-
If you are prompted, enter the password, and then click OK.
-
On the Review tab, Share Workbook.
-
On the Editing tab, clear the Allow changes by more than one user ... check box.
-
