Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Documenting external query for PivotTables
I am trying to write a macro that will document the connection string and
SQL code used to pull external data into my PivotTables. I know that the information I want is in the SourceData property in each of my PivotTables. Problem is, sometimes I have multiple PivotTables in a file that "link" back against a source PivotTable (i.e. Right click in the pivot table and select PivotTable Wizard... Click the < Back button... Click the next < Back button... Select the "Another PivotTable report or PivotChart report" radio button and click Next ... Select the pivot table containing the same data and click Finish). I don't want to document the same SQL code over and over again. If my Excel file has just a single "master" query, then that's all I want to document (on the other hand, if each PivotTable in my file is, indeed, different, then I want to see them individually). I can't seem to find how to tell if the data in any given PivotTable is obtained directly from the SQL statement, or whether it comes from a "master" PivotTable. TIA, Tim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Documenting spreadsheets | Excel Discussion (Misc queries) | |||
Chart Documenting Via VBA Questions | Charts and Charting in Excel | |||
Sending pivottables to external users | Excel Discussion (Misc queries) | |||
How do I update a ODBC query in Excel using pivotTables in VBA? | Excel Programming | |||
Pivottables from external sources | Excel Programming |