help on pivot tables using external data sources
 

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?

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