Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Data
Hi,
I have multiple pivots on an excel spreadsheet reading data from an external data source. All the pivots are feeding from the same data source but showing different information. When I need to change the data source I need to go through all the menu systems to get to the external data source information. i.e. Data, Pivot Table and Pivot Chart Report etc etc. I have tried recording a macro to do this but it does not seem to work. Is there not some VBA code I can use so it can take me straight into the Pivot Table and Pivot Chart wizard without going through the menu systems?? Please help!! Thanks Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot tables - Editing the data source shared by multiple pivot ta | Excel Discussion (Misc queries) | |||
Distributing Pivot Tables where pivot table data can't be accessed | Excel Discussion (Misc queries) | |||
Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
Data Area of Pivot Table and Pivot Charts | Charts and Charting in Excel |