| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Datasource for pivot tables
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Datasource for pivot tables
Ron Coderre has a pivot table add-in that lets you view and edit the
connection string: http://www.contextures.com/xlPivotPlay01.html bill wrote: 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 Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Datasource for pivot tables
Wow. Thanks for the reponse. I just ordered your book.
"Debra Dalgleish" wrote: Ron Coderre has a pivot table add-in that lets you view and edit the connection string: http://www.contextures.com/xlPivotPlay01.html bill wrote: 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 Contextures http://www.contextures.com/tiptech.html |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Datasource for pivot tables
You're welcome! Thanks for ordering the book, and I hope you find it useful.
bill wrote: Wow. Thanks for the reponse. I just ordered your book. "Debra Dalgleish" wrote: Ron Coderre has a pivot table add-in that lets you view and edit the connection string: http://www.contextures.com/xlPivotPlay01.html bill wrote: 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 Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| synchronising pivot tables | Excel Discussion (Misc queries) | |||
| Pivot Tables -changing datasource for exsting Pivot Table | Setting up and Configuration of Excel | |||
| Refreshing Pivot Tables linked to Oracle Datasource | Excel Discussion (Misc queries) | |||
| How to pull numbers from two tables with conditions? | Excel Worksheet Functions | |||
| Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
Hybrid Mode
