Determine the location of an external source of pivot table?

[Pivot Novice]

In Excel 2003, I have a pivot table linked to an Access database. How can I
determine the location of the database from within Excel? When I use the
Pivot Table Wizard, the "Get Data" button skips the location of the file and
immediately asks me which fields I want to import.

 

[Debra Dalgleish]

You can use programming to view the connection. For example:

Sub ViewCommandText()
MsgBox ActiveWorkbook.PivotCaches(1).Connection
End Sub

 

[Pivot Novice]

Thanks again, Debra. Your solution worked perfectly, again.

 

[Debra Dalgleish]

You're welcome! Thanks for letting me know that it worked.