I have the code below which refresh's all pivot tables found in a workbook however I would ideally like to edit this so the
macro will open all worksbooks found in a set folder, then run the 'refresh pivot tables' code.
Dim PT As PivotTable
Dim WS As Worksheet
For Each WS In ThisWorkbook.Worksheets
For Each PT In WS.PivotTables
I am having trouble figuring out how to incorporate both these into one macro (if possible)
So the outcome of the
macro would be, open 1st workbook, update pivot tables, save & close. Open 2nd workbook, refresh pivot tables, save &
close etc... until all works have been opened/refreshed.
Does anyone know a way to do this?