View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
aewilliam aewilliam is offline
external usenet poster
 
Posts: 1
Default PivotCharts and recalculating workbooks

Hi!
I have a big worksheet, with LOTS of formulae, so ihave 'MANUAL' calculate
turned on, and 'Recalculate before Save' turned OFF.
This saves me around 10-15minutes of calculations.

I also have a PivotTable and PivotChart that runs off this very large
worksheet, in the same workbook.

HOWEVER...
Very often...not everytime...whenever i change items on the PivotChart/Table
(e.g. drag/drop any items/data to remove/add, or even when changing between
COUNT to SUM - the workbook recalculates!!!
So yes, this could take HALF an hour of recalculating when all I want to do
was apply a filter and add a different item of data.

Is there any way to stop this recalculation?

Any help/suggestions would be GREATLY appreciated!!! =)