Can I use pivot table as data source?

Can I use pivot table as data source?

In a new sheet (where you want to create a new pivot table) press the key combination (Alt+D+P). In the list of data source options choose “Microsoft Excel list of database”. Click Next and select the pivot table that you want to use as a source (select starting with the actual headers of the fields).

How do I add a data source to a pivot table?

Create a PivotTable with an external data source

1. Click any cell on the worksheet.
2. Click Insert > PivotTable.
3. In the Create PivotTable dialog box, under Choose the data that you want to analyze, click Use an external data source.
4. Click Choose Connection.

How do I view a PivotTable?

To see the PivotTable Field List:

1. Click any cell in the pivot table layout.
2. The PivotTable Field List pane should appear at the right of the Excel window, when a pivot cell is selected.
3. If the PivotTable Field List pane does not appear click the Analyze tab on the Excel Ribbon, and then click the Field List command.

How do I change the source of a PivotTable?

To update the information to match the data source, click the Refresh button, or press ALT+F5. You can also right-click the PivotTable, and then click Refresh. To refresh all PivotTables in the workbook, click the Refresh button arrow, and then click Refresh All.

When should I use a PivotTable?

A pivot table is a summary of your data, packaged in a chart that lets you report on and explore trends based on your information. Pivot tables are particularly useful if you have long rows or columns that hold values you need to track the sums of and easily compare to one another.

How do you use data in a pivot table formula?

Click the PivotTable. On the Options tab, in the Tools group, click OLAP tools, and then click Convert to Formulas. If there are no report filters, then the conversion operation completes. If there are one or more report filters, then the Convert to Formulas dialog box is displayed.