PivotCharts and recalculating workbooks

[aewilliam]

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!!! =)

 

[evoxfan]

A pivot table shows items based on the results of formulas.
So Every time you drag or drop from a pivot table it is going to show you
the results from your formulas. So if you have the automatic calculation off
it will have to calculate formulas every time you drag or drop an item not
just when you refresh the pivot table data. Refreshing the data is only for
when your data changes such as deleting or adding an item but not for
calculations that are already in place.

If you have not tried this already, turn on your automatic calculations and
let it complete its calculations. Then go to your pivot table and drag or
drop an item and see if it takes the same amount of time. If this is still
taking too long for you, you may consider dividing your data into different
fiiles. If you can split up your data, put some of it in another data file
with another pivot table. Then combine all your data into one file with
another pivot table based on the two or three or four other sub pivot tables.

These are the only suggestions I can offer. If it does not work maybe somone
more advanced will help you.

Good luck.