Pivot table auto-refresh when data changes?
Posted by Jennifer Johnson on November 03, 2001 2:34 AM
Can someone help me? I'd like to know if it's possible to have a pivot table automatically refresh itself after data is changed in the source table. I have seen previously on this site where it is possible to do this when the worksheet gets re-activated, but is there such a way to have it refresh as soon as the data is changed? My source table and pivot table are on the same sheet. Thanks so much if you know a way.