Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivots using other pivots and dynamic query problem
Hi,
I have one PivotTable that gets refreshed by macro using cell values. New query (from sql server) is loaded into PivotCache.CommandText. This works just fine. Since the query can be quite lengthy (wouldn't want to fire it twice to present 2 views), I created another PivotTable that uses the former one as a source. Well. now assigning PivotCache.CommandText no longer works with 1004 error. Does anyone have any idea what might be the problem? (Using 2003) TIA lc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivots and Functions | Excel Worksheet Functions | |||
several pivots | Excel Discussion (Misc queries) | |||
Formats and Pivots | Excel Discussion (Misc queries) | |||
Automatic pivots | Excel Discussion (Misc queries) | |||
Quickie on Pivots | Excel Discussion (Misc queries) |