Hi Mohamed, What i did was simply set the pivot in your sheet "refresh when opening the file" ("refresh data when opening the file" in Pivot Table Options tab DATA) and after you paste the data you close the file and open again and the pivot is refre...
