Activate a PivotTable list, spreadsheet, or chart on a data access page

Activate a PivotTable list, spreadsheet, or chart on a data access page

Activating one of these Microsoft Office Web Component controls is not the same as selecting the control it. When you select the control, you’re selecting the outer control. Once the outer control is selected and has the focus, you can move the focus inside the control to activate its contents. Once its content is activated, you can set properties and work with the features of the control. For example, in a PivotTable list, you can move columns and rows, or otherwise work with its layout and data.

Selected and activated PivotTable list controls

Once the content is activated, you can select different parts of the Web component to set properties for the selected part.