Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Needed for Pivot Table
All,
I have many pivot tables on many sheets in a single workbook. Each of these may have a diffrent data source pointing to MS SQL. What I would like is a Macro to run which tells me something like this: SheetName PivotTable Name Data Souce Sheet1 PT1 DB.my.mytable Is there an easy way to loop through this? I do not want to go through over 50 Pivot Tables and the wizard to get this info. Too time consuming. Thanks in advance for any help or suggestions. Doug Fast |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculation needed maybe a pivot table - Thank you | Excel Discussion (Misc queries) | |||
Pivot Table Help Needed!!!! | Excel Discussion (Misc queries) | |||
Pivot Table Assistance Needed | Excel Worksheet Functions | |||
Pivot table subtotals help needed | Excel Discussion (Misc queries) | |||
Pivot table help needed | Excel Programming |