Hi All.........
I'm having a heck of a time with Excel97,SR2.

I have a macro which runs a MSQuery and returns data to my Excel sheet from
an outside database. It works fine when run by itself.

I have another macro which runs a Pivot Table on that data. It works fine
when run by itself.

When I try to call the second macro from the first, I get error message "Run
time error '1004', AddFields method of Pivot Table class failed". Yet each
macro will run individually and the whole thing will run if stepped through
from the beginning by hand. This combination of macros is for retrieving
Materials Data. I have another pair, very nearly the same which retireve
Labor Data and they run together just fine.

I've tried changing the name of the called macro, and using both "Call
PivotMaterials" and "Application.run "PivotMaterials"".....no difference.

Any help would be much appreciated...

Vaya con Dios,
Chuck, CABGx3