Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!! =) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
PivotCharts and recalculating workbooks
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. "aewilliam" wrote: 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!!! =) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivotcharts and stored procedures | Charts and Charting in Excel | |||
PivotCharts and series order | Charts and Charting in Excel | |||
Dates in Excel PivotCharts | Charts and Charting in Excel | |||
Having an issue with some pivotcharts? | Charts and Charting in Excel | |||
PivotCharts (max cell/row limits)? | Charts and Charting in Excel |