Are you sure that's the name of the pivot table on the active sheet?


Paul Dennis wrote:
Can anyone help with this error please, when I run the following statement in
my macro

ActiveSheet.PivotTables("DataPivot").PivotCache.Re fresh


Runtime error 1004

Unable to get the PivotTable properties of the worksheet task


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html