Determine the location of an external source of pivot table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You can use programming to view the connection. For example:

Sub ViewCommandText()
MsgBox ActiveWorkbook.PivotCaches(1).Connection
End Sub
 
You're welcome! Thanks for letting me know that it worked.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table data source 1
Can a pivot table be redirected to an external source? 1
Pivot Table Source 3
Pivot Table with source spread across multiple worksheets 1
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pivot Table Wizard causes crash 1
Pivot table results error 1
Pivot Tables- SQL Alias' & Field Lists 1

Back
Top