Pls assist How 2 find Mystery in complex pivottable data source base on access

[Ehud_B]

Hi there,
I was asked to maintain a complex system in which pivottable are base
on access object (MDB)
I went into the wizard returned to the fields making the pivottable
Went through all the queries and tables in the MDB but could not find
out where the pivottable (excel) is getting the (wrong) data.
Is there a way to see the SQL which makes the pivottable??
Any advice will be appreciated

 

[Debra Dalgleish]

You could run a macro to view the pivot cache's command text. For
example, the following code would print the text in the Immediate window
of the Visual Basic Editor:

Sub ShowCommandText()
'show pivot table command text
Debug.Print ActiveWorkbook.PivotCaches(1).CommandText
End Sub