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.