I have developed a workbook with ~36 Pivot Tables that all have unique names. I am trying to automate the refresh mechanism for these pivot tables, I have tried using ActiveWorkbook.RefreshAll but the issue is that I have to run the code 4-5 times before it cycles through all the pivots. What I am trying to do is write a macro in VBA that refreshes each Pivot Table by assigned name in order.
Is there a way to cycle through Pivot Table refreshes in VBA using their names? I'm hesitant to cycle through each sheet because sheets names will frequently change.