VBA Refresh All Pivot Tables

[Mudbutt]

Is there a difference between these two procedures to refresh all pivot tables on a workbook? I've been finding that not all my pivots have been refreshing with this first option so I was going to try the second one I have here. Any ideas?

#1

For Each ws In Activeworkbook.Worksheets
        For Each pt In ws.PivotTables
            pt.RefreshTable
        Next pt
    Next ws

#2

Activeworkbook.RefreshAll

 

[RoryA]

The first one still works. What's the data source for the pivot tables?

 

[goochspaintball]

The first one still works. What's the data source for the pivot tables?

My source is a data tab within the workbook, nothing really fancy.

I was trying to link a button (Form Control button) to a refresh pivots macro. I want to prompt the refresh of all my pivots only, but the "RefreshAll" macro is the only thing that would work. I don't necessarily want "all" updated, as I have an ODBC-linked table that others do not have the connection to, nor authority to connect.

It's been a while since I did this, but it worked in 2003.

Thanks, Bill

 

[RoryA]

So if you manually change some of the existing data and run that code, the pivots don't alter?

 

[CatyH]

I'm not positive, but unless you have Calculation set to manual, that seems unlikely to me.
...

THANK YOU for posting that! I have a macro that used to crash and the Calc was set to manual and wasn't being reset! I had forgotten to check that! Yes! THANK YOU!