Well, following my last post, it seems that I have one question remaining from the series:

Sheets("Sheet2").PivotTables("PivotTable1").Refres hTable

Sheets("Sheet2").PivotTables("PivotTable1").PivotC ache.Refresh

The above 2 lines both "seem" to have the same effect.

Is one better than the other? Do they in fact simply do the same thing?