How do I selectivly refresh pivottables in a workbook?

Hi All,

I have two worksheets each containing a few pivottables. I would only want to refresh 3 pivot tables out of a possible 10 in this workbook.
From the below code, pivottable 1 and 4 is on one worksheet, pivottable 8 is on another - the code will need to go through all the pivot tables in the workbook and update these 3 only.

I have attempted the below code but there is an error. Can someone please let me know what is wrong.

Thanks!

Please Login or Register  to view this content.

There's not a lot of point in looping - you can just refresh them directly:

Please Login or Register  to view this content.

for example.

Yes but it would be safer (in case the users move things) to use the code name assuming the code is in the same workbook.

In the Project Explorer window in the VB Editor, you will see for each sheet a name followed by another name in parentheses - e.g. Sheet1 (some sheet)

Sheet1 is the codename (the name in parentheses is what you see on the sheet tab) and can be used as a variable:

Please Login or Register  to view this content.

It is usually best to rename the codename to something more meaningful using the properties window.