Pivot Table Source Worksheet and Range

G

Guest

Is there a way to view in a pivot table sheet which of the other worksheets
in a workbook it derived from, and what was its original range within that
raw data worksheet?
 
D

Debra Dalgleish

In Excel 2003, and earlier versions, right-click a cell in the pivot
table, and click PivotTable Wizard.
Click Back, and you'll see the range address or name. In most cases, the
range will be activated on the worksheet in the background.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table using dynamic worksheets 2
Pivot Table Data Source 1
Value filter missing in pivot table 3
Excel 2007 pivot table source table 1
Cannot Open Pivot Table Source File 0
Pivot table change data source 1
Pivot Table Refresh not working properly 1
Pivot Table Field History 1

Top