Pivot Table

[DaveB]

After I have created my Pivot Table, how do I find the
source data from the Pivot Table i just created. Thanks in
advance.

DaveB

 

[Toby Erkson]

This is from a previous answer I gave:
"...to change the source data (where the pivot table pulls its
information from) you right click on any field in the pivot table, select
"Wizard...", and then click the "<Back" button.
- If the data is within the workbook you will see the sheet and the range will
be outlined.
- If the data comes from an outside source, like Access or a SQL db, then you
will click the button that says, "Get Data...", which will take you to the
[external] data source. You are on your own at that point on getting the
data."