Pivots using other pivots and dynamic query problem

[lc]

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