Datasource for pivot tables

[Guest]

I've inherited some spreadsheets w/ pivot tables. How can I find what the
datasource is and the query it is using to get data from a mdb?

 

[Debra Dalgleish]

Ron Coderre has a pivot table add-in that lets you view and edit the
connection string:

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

 

[Guest]

Wow. Thanks for the reponse. I just ordered your book.

 

[Debra Dalgleish]

You're welcome! Thanks for ordering the book, and I hope you find it useful.