Refresh pivot table w/External Data Source in VBA

[bButler]

I have a very simple pivot table that is pointing to Oracle that refreshes nicely from the workbook (Data - Refresh Data). However, when I try to refresh the PT from in VB, I get the dreaded "Run-time error '1004' Application-defined or object-defined error". I recorded the data refresh, thinking maybe I coded something wrong, but even that won't work (though the recording worked fine). Here it is, just one line . . .

Sub TEST4()
Sheets("PT").Select
ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh
End Sub

Does this just not work? or am I missing a class?

Thanks for your help!

Betsy