Hi there,
I'd like to know how to have a pivot table automatically refresh itself as soon as data is changed in the source table. My source data and pivot table are on the same workbook, and I have 2 pivot tables(in different sheets) with same source data (in another sheet).
Thanks in advance..![Smile :-) :-)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
I'd like to know how to have a pivot table automatically refresh itself as soon as data is changed in the source table. My source data and pivot table are on the same workbook, and I have 2 pivot tables(in different sheets) with same source data (in another sheet).
Thanks in advance..
![Smile :-) :-)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)