Refering to a pivotTable in vba

[j_Southern]

I have a worksheets with two PivotTables on each. I use the following sub to refresh them.

Please Login or Register  to view this content.

The tables in the first sheet are labelled 1 and 2 and they both refresh as expected.
The tables in the second sheet are labelled 1 and 4. Excel labelled these for me, probably using 4 because I had several attempts at arranging this table.
The Pivottable 1 refreshes pivottable 4 does not but gives an error message "Unable to get PivotTable of the worksheet class" which I take to mean that it can't find PivotTable4
Why should this be so, and what should I do to solve the problem?
John

[CK76]

Why refresh individually?

You can simply use...

Please Login or Register  to view this content.

To refresh all pivot tables.

If for some reason, you need to refresh individually. Try checking for name using something like below.

Please Login or Register  to view this content.

[j_Southern]

CK76
I have to refresh separately because the second pivot takes the first plus some calculated columns as its input.
I used your demo sub and this confirmed that the pivot in question was called Table4. I can't see any typos so I am at a loss as what to do.
I am going to change the table name to Table2 and see what happens.
John