Content Conversations

Adding the Share Workbook and Track Changes Legacy Features in Excel 2016

With a software update to certain versions of Excel in late summer 2017, Microsoft bought in a new co-authoring feature to support sharing of workbooks online. At the same time, Microsoft designated the Share Workbook and Track Changes as legacy features and removed them from the Excel ribbon. These legacy features are still available to users who want to add them to their version of Excel.

The Share Workbook and Track Changes features are useful for sharing a workbook on a network drive rather than online. You may add them to the Quick Access Toolbar, or you may add them to the Excel ribbon by creating a new group and adding them to the new group.

Add the Share Workbook and Track Changes Legacy Features to the Quick Access Toolbar

  1. Click the Customize Quick Access Toolbar button at the right of the Quick Access Toolbar and then click the More Commands option at the drop-down list.
  2. Verify that the Quick Access Toolbar option is selected in the left panel at the Excel Options dialog box, click the Choose commands from option box arrow in the right panel, and then click either the Commands Not in the Ribbon option or All Commands option at the drop-down list.
  3. Scroll down the Commands Not in the Ribbon or All Commands list box and then double-click the Share Workbook (Legacy) option. The Share Workbook (Legacy) command is added to the Customize Quick Access Toolbar list box.
  4. Scroll down the Commands Not in the Ribbon or All Commands list box and then double-click the Track Changes (Legacy) option. The Track Changes (Legacy) command is added to the Customize Quick Access Toolbar list box.
  5. Click the OK button.
  6. The Share Workbook (Legacy) and Track Changes (Legacy) commands are added to the right side of the Quick Access Toolbar.

Add the Share Workbook and Track Changes Legacy Features to the Ribbon

  1. Click the File tab.
  2. Click the Options option in the left panel at the backstage area.
  3. Click the Customize Ribbon option in the left panel at the Excel Options dialog box.
  4. Click the Review option in the Main Tabs list box in the right panel.
  5. Click the New Group button.
  6. Verify that the New Group (Custom) option is selected in the Main Tabs list box and then click the Rename button.

  1. With the text selected in the Display name text box at the Rename dialog box, type Collaborate. (Do not type the period.)
  2. Click the OK button.

  1. Click the Choose commands from option box arrow in the right panel at the Excel Options dialog box and then click either the Commands Not in the Ribbon option or All Commands option at the drop-down list.
  2. Scroll down the Commands Not in the Ribbon or All Commands list box and then double-click the Share Workbook (Legacy) option. The Share Workbook (Legacy) command is added to the Customize Quick Access Toolbar list box.
  3. Scroll down the Commands Not in the Ribbon or All Commands list box and then double-click the Track Changes (Legacy) option. The Track Changes (Legacy) command is added to the Customize Quick Access Toolbar list box.
  4. Click the OK button.
  5. The Share Workbook (Legacy) and Track Changes (Legacy) commands are added in the new group Collaborate on the Review tab of the Excel ribbon.

Affected Courseware
Advanced Microsoft® Excel® 2016, Chapter 14, Sections 14.3 and 14.4 (textbook pages 685–693)
Benchmark series, Microsoft® Excel® 2016, Level 2, Chapter 6 (textbook pages 147–154)