Finding Pivot Tables

[EdE]

This is kind of odd. I have a basic macro to update pivottables on various tabs of a worksheet. However, some users will add tables from time to time and then do the macro, which doesnt update their new table. Is there a way to just update all the tables on a tab without selecting each one individually?

Thanks~

 

[Mark W.]

ActiveWorkbook.RefreshAll

 

[EdE]

Thanks Mark. I didnt think it was that simple!