Pivot Table - Select Source

Opens a dialogue box where you can select the source for your pivot table, and then create your table.

To access this command...

Choose Insert - Pivot Table.

Selection

Select a data source for the pivot table.

Current Selection

Uses the selected cells as the data source for the pivot table.

The data columns in the pivot table use the same number format as the first data row in the current selection.

Data source registered in Office

Uses a table or query in a database that is registered in Office as the data source for the pivot table.

External source/interface

Opens the External Source dialogue box where you can select the OLAP data source for the pivot table.

Pivot table dialogue box