Determine the location of an external source of pivot table? in Excel Worksheet Functions  
 |  Edit my Profile  |  Help
 
     
   
 
 
 
Pivot Novice 5/31/2005 4:23 PM PST
  Question
  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.
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Debra Dalgleish 5/31/2005 5:28 PM PST
  Answer
  You can use programming to view the connection. For example:

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


Pivot Novice wrote:
> 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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Pivot Novice 6/1/2005 8:42 AM PST
   
  Thanks again, Debra. Your solution worked perfectly, again.

"Debra Dalgleish" wrote:

> You can use programming to view the connection. For example:
>
> Sub ViewCommandText()
> MsgBox ActiveWorkbook.PivotCaches(1).Connection
> End Sub
>
>
> Pivot Novice wrote:
> > 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
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Debra Dalgleish 6/1/2005 1:36 PM PST
   
  You're welcome! Thanks for letting me know that it worked.

Pivot Novice wrote:
> Thanks again, Debra. Your solution worked perfectly, again.
>
> "Debra Dalgleish" wrote:
>
>
>>You can use programming to view the connection. For example:
>>
>>Sub ViewCommandText()
>> MsgBox ActiveWorkbook.PivotCaches(1).Connection
>>End Sub
>>
>>
>>Pivot Novice wrote:
>>
>>>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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
  Return to Microsoft Communities  Notify me of replies