Excel Pivot Table: How to recalculate automatically ?
by rcgyuk - 2/19/10 1:32 AM
I have a question regarding pivot tables.
At present, If the data in my sheet changes, the ordinary parts of the spreadsheet recalculate with no action on my part. (Providing that calculation is set to auto not manual)
However, I have to remember to then go to the pivot tables in my spreadsheet, and recalculate each one manually, to reflect the changed data.
Is there some way I can make it so I don't have to do this?
I know macros can be set to be triggered by certain events, I already use macros that are called auto_open and auto_close, I think what I want is a macro that is triggered by the spreadsheet recalculating, which will then in turn select the pivot table and recalculate it, but this is where I get lost.
Can anyone help me out here?