I'm working with a large pivot table file ( 25mb ) that the company
publishes and re-aranging the fields via code takes a very long time. Is
there a way to disable calculation of the data fields and then manually
update them at the end?

Also would removing all the data fields and then re-adding them last speed
up the process?

Jesse

Jesse, say your pivot table object is called PT, you could put

PT.ManualUpdate = True

then set it back to False when you're done rearranging, or it will
automatically set itself back to False when your code ends.

"Jesse Hamilton" wrote:

I'm working with a large pivot table file ( 25mb ) that the company
publishes and re-aranging the fields via code takes a very long time. Is
there a way to disable calculation of the data fields and then manually
update them at the end?

Also would removing all the data fields and then re-adding them last speed
up the process?

Jesse