asked on
ASKER
Worksheets("Data").Select Range("B6").Select ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh
Select allOpen in new window
ASKER
Open in new window
being used on the Excel file. How to ensure it would work fine, on Excel 2007 version?