Refreshing Pivot tables

Hi,
I have a pivot table analysing a dynamic table which I refresh as follows

Sub RunLabelPivot()
With Sheets("LabelPivot")
 .PivotTables("PivotTable2").PivotCache.Refresh
End With
End Sub

This is a technique I have used, unthinkingly, many times without a problem,using Excel 2000. I now have Excel 2010
After seeing some anomolous results I discovered by looking at the data source that the Pivot was only analysing a portion of the data table.
How can I tell the Pivot that it has to look for the whole of a dynamic table?
John

Try this

Sub RefreshPivotButton()
'
' RefreshPivotButton Macro
'

'
    ActiveSheet.PivotTables("Programs Title").PivotSelect "'Programs Title'[All]", _
        xlLabelOnly, True
    ActiveWorkbook.RefreshAll
End Sub

by changing the "program title" to the name of your pivot table. Which you can find in options for pivot table.

Does this help?

by changing the "program title" to the name of your pivot table. Which you can find in options for pivot table.

Does this help?