Pivot Table (display source data)
 

Hi there!
I created a Pivot Table (Excel 2003) from a sheet and now want to see (from
the Pivot Table tab), what source I used to create the Pivot Table.

Where can I click to find the "Range of the Source"?
THANKS!
Gene:)

Pivot Table (display source data)
 

Gene,

If you right-click on the PivotTable itself, click PivotTable Wizard, and
finally click Back, it will show you the Source data being used to populate
the table.

"Gene" wrote:

Hi there!
I created a Pivot Table (Excel 2003) from a sheet and now want to see (from
the Pivot Table tab), what source I used to create the Pivot Table.

Where can I click to find the "Range of the Source"?
THANKS!
Gene:)

Pivot Table (display source data)
 

THANK YOU! THANK YOU! THANK YOU!

"Gene" wrote:

Hi there!
I created a Pivot Table (Excel 2003) from a sheet and now want to see (from
the Pivot Table tab), what source I used to create the Pivot Table.

Where can I click to find the "Range of the Source"?
THANKS!
Gene:)

Pivot Table (display source data)
 

On Jun 24, 1:05*am, Gene wrote:
THANK YOU! THANK YOU! THANK YOU!



"Gene" wrote:
Hi there!
I created a Pivot Table (Excel 2003) from a sheet and now want to see (from
the Pivot Table tab), what source I used to create the Pivot Table.

Where can I click to find the "Range of the Source"?
THANKS!
Gene:)- Hide quoted text -

- Show quoted text -

You can also create a pivot, using the excel data, in sisense (http://
www.sisense.com) and this will be easier to maintain in the future.