View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jesse Hamilton[_3_] Jesse Hamilton[_3_] is offline
external usenet poster
 
Posts: 1
Default Pivot table recalcuate disable

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