Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
disable get pivot table function | Excel Worksheet Functions | |||
disable autosorting in Pivot Table Excel 2000 | Excel Discussion (Misc queries) | |||
Pivot Table - Disable the Show/Hide Detail upon refresh | Excel Discussion (Misc queries) | |||
Right Click Pivot table - Wizard - Back button is disable | Excel Discussion (Misc queries) | |||
Disable "Select Multiple Items" in Pivot Table | Excel Programming |