Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Excel Pivot Table: How to recalculate automatically ?

Feb 18, 2010 5:32PM PST

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?

Robert

Discussion is locked

- Collapse -
What version of Excel?
Feb 18, 2010 5:40PM PST

95, 97, 2000, XP=2002, 2003, 2007? Or even a Mac version?

Might make a difference.

Kees

- Collapse -
Excel 2003 in XP
Feb 18, 2010 5:59PM PST

Excel 2003 in XP

- Collapse -
Found a solution
Feb 18, 2010 6:54PM PST
- Collapse -
(NT) Thanks for the link.
Feb 18, 2010 6:57PM PST