View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JAdamJ JAdamJ is offline
external usenet poster
 
Posts: 4
Default Pivot table recalcuate disable

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