• Document Properties Definition
• Add Document Properties Excel 2016
• Add Custom Document Properties Excel Vba
• Add Document Properties In Excel

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

Step 1: Open the new or an existing Word document. Step 2: Click on the File tab at the top left corner of the document. Step 3: A list of file options will appear on the screen with the selected Info tab. Step 4: Click on the drop-down menu associated with the Properties. Select Advanced Properties from the Properties drop-down menu. About Press Copyright Contact us Creators Advertise Developers Terms Privacy Policy & Safety How YouTube works Test new features Press Copyright Contact us Creators. Add or Modify Properties. In the desktop, click or tap the File Explorer button on the taskbar. Click or tap the file you want to add or modify properties. In the Details pane, click or tap the tag you want to change, and then type the new tag. To display the Details pane, click or tap the Details pane on the View tab.

If you don't find the info you want, such as file size or who it was last saved by, you can use field codes to add a variety of document properties. Note: If you already added a header or footer from the gallery, this procedure may replace or change the formatting of the current header or footer. Check if all documents have the same behavior. Open ExcelFileAccountcapture a screenshot of all info under Product Information. If anything is misunderstood, please share with us more details about how you add custom document property and capture a screenshot of 'Custom tab are grayed out'.

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 QuickAccessToolbar option is selected in the left panel at the Excel Options dialog box, click the Choosecommandsfrom option box arrow in the right panel, and then click either the CommandsNotintheRibbon option or AllCommands 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.

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

Document Properties Definition

9. Click the Choosecommandsfrom option box arrow in the right panel at the Excel Options dialog box and then click either the CommandsNotintheRibbon option or AllCommands option at the drop-down list.
10. 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.
11. 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.
12. Click the OK button.
13. 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)

Popular Posts

Add Document Properties Excel 2016

Add Custom Document Properties Excel Vba

Contact

Courseware

Microsoft Office Application

Add Document Properties In Excel

Archives