Pivot Table (display source data)

[Gene]

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

 

[Thomas [PBD]]

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]

THANK YOU! THANK YOU! THANK YOU!

 

[roni]

THANK YOU! THANK YOU! THANK YOU!






- 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.