How to stop every pivot updating when I edit one

[masplin]

I have a workbook with maybe 30 pivots. If I add a new field to one pivot it tries to refresh the whole workbook not just the one I'm editing. Means I have to hit esc many times to stop it which takes ages. Can this behaviour be prevented?

Thanks

Mike

 

[andrew69]

Have a read of http://www.mrexcel.com/forum/showthread.php?24816-Application-Calculation-xlManual

 

[masplin]

It is already in manual. Still runs every pivot table when I add a field to one.

 

[MartinL]

I have a workbook with maybe 30 pivots. If I add a new field to one pivot it tries to refresh the whole workbook not just the one I'm editing. Means I have to hit esc many times to stop it which takes ages. Can this behaviour be prevented?

Thanks

Mike

1 good turn
although you will probably not like this Mike

http://www.excelforum.com/excel-200...vot-table-within-a-mulit-sheet-pivot-doc.html

Martin

 

[masplin]

If only I knew what seperate caches meant!!!