Pivot Tables Not Refreshing

[Mudbutt]

I'm running this code, yet there are a couple of pivot tables on my workbook that don't seem to be refreshing when i run it. I have 10+ pivot tables in the workbook, but when i check them by refreshing each one individually, there are a couple on one of the worksheets that change...meaning it wasn't refreshed by this code. What would the reasoning be? There are no restrictions whatsoever on the workbook or worksheets:

Dim ws As Worksheet
    Dim pt As PivotTable
For Each ws In Activeworkbook.Worksheets
        For Each pt In ws.PivotTables
            pt.RefreshTable
        Next pt
    Next ws

 

[Derek Brown]

You did not say which version of Excel is being used.

' does using:
        pt.PivotCache.Refresh
' instead of:
        pt.RefreshTable
' make any difference?

 

[Mudbutt]

I apologize, I'm using 2007. I can try that...

 

[Mudbutt]

No, it didn't except that line of code.