Show data as hyperlinks in PivotTable view

You can choose to display data as hyperlinks in a row, column, or detail field by changing the field's property settings. When data is displayed as hyperlinks, users can click them to navigate to other Web pages or objects.

  1. Open a datasheet or form in PivotTable view.
  2. Click the row, column, or detail field that contains hyperlinks.
  3. On the PivotTable toolbar, click Properties , and then click the Format tab.
  4. Select the Display as hyperlink check box.