Thread: help on pivot tables using external data sources
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
  
Posts: 2,979
Default help on pivot tables using external data sources
Ron Coderre has a pivot table add-in that lets you view and edit the
connection string and command text:

http://www.contextures.com/xlPivotPlay01.html


Tewari wrote:
I have a pivot table created froma an external database i.e. access
database.
I want to change the query but I am not able to do it as edit query
option is disabled.
Any help on how to dit?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply With QuoteReply With Quote