Macro that refreshes pivot tables

I have a macro that inserts additional columns to my data. The code that I am using to refresh the pivot tables linked to the data does not work. I believe the issue is that the field in the pivot is one of the columns that gets added by macro.

Is there a pivot table refresh code that can be used to incorporate the now updated data?

The code I used (that doesn't work):

Please Login or Register  to view this content.

Hi NeedforExcel, attached is what my data and linked pivots look like. Running the code below will work just fine (my intention is to get it to filter for each VP in the pivot tables). But if you were to delete all of the rows except for, say, the top 10, and try to rerun the code, the code will not filter for each VP. I get a "Run Time error 1004" message (application defined or object defined error). Since this code will be used as a template, I have to be able to account for the row count changing week to week.

Please Login or Register  to view this content.

I found that refreshing the pivot cache solves the problem. I used the code below.

Please Login or Register  to view this content.