ExcelBanter - Pivot Tables

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot Tables (https://www.excelbanter.com/excel-discussion-misc-queries/49996-pivot-tables.html)

Lisa

Pivot Tables

How do I identify the source data in an existing Pivot Table?

cottage6

Hi Lisa,
Right-click an area of the pivot table, and click on "Wizard". When the
Wizard opens it'll be on Step 3, but if you click the "Back" button it'll
move to Step 2 which should show you the data range.

"Lisa" wrote:

How do I identify the source data in an existing Pivot Table?

All times are GMT +1. The time now is 11:33 AM.