How do I view Pivot Table source data file and field names?

Originally Posted by chocolate2346

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