Stan

Thanks for the reply, and sorry for being slow in following up.

I liked your first suggestion methodology, since I can specify the name
and the function of the pivot field, before it 'appears'. However, I'm
struggling to find this AddDataField method within my object library.
Is this specific to more recent versions of Excel, or is it something
else that I'm missing out on? (I'm using French Excel 2000)
Regards

Mohsen