How to Enable the Shared Workbook Feature in Excel.

Enabling the Shared Workbook feature

1. Create a new workbook or open an existing workbook. Then place it on a network location. For example, A Folder on the P: Drive.
2. Click Review > Share Workbook.

Note that in newer versions of Excel, the Share Workbook button has been hidden. See Add Shared Workbook buttons below.

3. On the Editing tab, select the Allow changes by more than one user ... check box.
4. On the Advanced tab, select the options that you want to use for tracking and updating changes, and then click OK.
5. 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.
6. If the workbook contains links to other workbooks or documents, verify the links and update any links that are broken.
7. Click File > Save.
8. When you're done, - Shared will appear at the top of the Excel window, next to the filename.

Add Shared Workbook buttons to the Quick Access Toolbar

1. Select File > Options > Quick Access Toolbar.
2. Open the list under Choose commands from and select All Commands.
3. Scroll down that list until you see Share Workbook (Legacy). Select that item and select Add.
4. Then scroll through the list until you see Track Changes (Legacy). Select that item and select Add.
5. Scroll through the list until you see Protect Sharing (Legacy). Select that item and select Add.
6. Scroll through the list until you see Compare and Merge Workbooks. Select that item and select Add.
7. Select OK.
8. Now four new buttons will appear at the top of the Excel window.