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