Go to the Data tab, and click on Connections. Find the connection
you're looking for, click Properties, go over to the Definition tab,
and look in the Command Text box.

On Jan 10, 10:13 am, Marc Forget
wrote:
I'm trying to just view the current external data source of an Excel pivot
table. I can find the path to the Access database and the name of the
database, but I can't find the name of the table or query which actually
forms the basis for the pivot table.

From reading prior posts, I tried using the VBA command
MsgBox ActiveWorkbook.PivotCaches(1).SourceDataFile (or CommandText)
but this just tells me the path and database name again, not the table/query
name.

Is there a way to get this information?

Thank you.