chocolate2346 Wrote:
I'd like information on how you can view the name/reference for the
source
data of a Pivot Table. For Example, in MS Access and Cognos Impromptu
you
can go to SQL view and see where data in a Query is coming from. It's
easy
to find the source of formulas in Excel, using the Audit Toolbar. I'd
like a
way to quickly view the file name (whether an Excel file or external
source)
and field names that were used to create the Pivot Table.

Hi chocolate2346

Try this, right click on the Pivot Table, click Wizard, a dialogue box
will appear, click the Back button, a second dialogue box will appear
that shows the source of the data


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=467550