5+ How To Update A Pivot Table 2022. This macro creates a list of all the pivot tables in the active workbook, for sheets that have 2 or more pivot tables. From the pivottable options window, go to the data tab and check the refresh data when opening the file option. Here is How to …