You can use programming to print the commandtext:

Sub PrintCommandText()
Debug.Print ActiveWorkbook.PivotCaches(1).CommandText
End Sub


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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html