+ Reply to Thread
Results 1 to 7 of 7

How to see data connection from Pivot Table

  1. #1
    Registered User
    Join Date
    09-12-2007
    Posts
    7

    How to see data connection from Pivot Table

    Hello,

    I'm working on a workbook which contains numerous pivot tables using 50 odd data connections, I need a quick way to find out what connection is used from the pivot table. At the moment I have to go through each connection to see which pivot table uses it.

    Thanks

  2. #2
    Registered User
    Join Date
    09-23-2003
    Location
    Melbourne
    MS-Off Ver
    Excel 2003
    Posts
    27

    Re: How to see data connection from Pivot Table

    When you say data connections, do you mean that a sheet is pulling data from an external source, and a pivot table is working off that sheet?

    Brad.

  3. #3
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: How to see data connection from Pivot Table

    Perhaps something along the lines of:

    Please Login or Register  to view this content.

    Pending setup you might be able to just iterate the PT Caches in the Workbook.

  4. #4
    Registered User
    Join Date
    09-12-2007
    Posts
    7

    Re: How to see data connection from Pivot Table

    Quote Originally Posted by bradles View Post
    When you say data connections, do you mean that a sheet is pulling data from an external source, and a pivot table is working off that sheet?

    Brad.
    Yep, it's pulling data from MySQL. Just want a quick way of getting the connection name it's using

  5. #5
    Registered User
    Join Date
    09-12-2007
    Posts
    7

    Re: How to see data connection from Pivot Table

    Quote Originally Posted by DonkeyOte View Post
    Perhaps something along the lines of:

    Please Login or Register  to view this content.

    Pending setup you might be able to just iterate the PT Caches in the Workbook.
    Close but that doesn't return the connection name but the connection string

  6. #6
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: How to see data connection from Pivot Table

    you should find the WorkbookConnection property returns that for you, eg:

    Please Login or Register  to view this content.

    check out the VBA Object Browser if there are other things you'd like returned (eg underlying SQL etc...)

  7. #7
    Registered User
    Join Date
    09-12-2007
    Posts
    7

    Re: How to see data connection from Pivot Table

    That worked, thanks!
    Last edited by DonkeyOte; 02-15-2010 at 10:34 AM. Reason: unnec. quote removed

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1