I'm pretty sure that will do it... I'll test it now.

My guess is that after setting it back to auto, I'll need to refresh the
table.. but that's all fine.

It's in a subroutine that takes an array for the row fields, an array for
the colum fields, an array for the page fields, an array for the data fields,
etc... a callable Pivot Table creator...

I think your suggestion is the answer. Thanks for it.

Mark