Call Sub to update specific pivot tables

Hi all,

I have a quick question about updating specific pivot tables (on several worksheets) on click of a button. When I click the button, several subs are running (selected using Call) and so far everything is working fine:

Please Login or Register  to view this content.

Now, I am trying to get Macro 3 to run...so far without any luck.

I found several VBA macros online, however, none of them seem to work when 'called'. What I currently have is:

Please Login or Register  to view this content.

Note:
Pivot table is called Pivot_N and is on worksheet Pivot_N, however, I will need to add more pivots on other worksheets to this too...

Can't seem to get it to work....

Hope you can help?
Many thanks!

Hi all,

Any idea on how to solve this? Tried a few things, but no luck yet :-(

Many thanks

Hi rorya,

Sorry for the missing detail.

I get a run-time error 424: object required.

Not really sure what that means?
Many thanks!

Hi Rorya,

Ah, thanks for pointing that out. Fixed (but unfortunately same 424 object required error):

Please Login or Register  to view this content.

Pivot_N is the worksheet the pivot table "Pivot_N" is on. If it's of any help - each pivot table has a different name, but there is only 1 on each worksheet.
The following works to update all pivot tables, however, I only want to update specific ones with this macro...

Please Login or Register  to view this content.

Is it possible to tweak this to only update pivot tables or worksheets (with pivot tables on) I specify?

Many thanks for your help!

It's the tab name

Hi Rorya,

Thanks!! I think this works!

Many thanks for your help!