How to refresh Pivot tables on a worksheet (w/o using macro)

[ExcelPupper]

Is there a function in excel wherein all present pivot tables in a WORKSHEET could be updated simultaneously? I cannot use the refresh all function because other pivot tables on different WORKSHEETS don't need to be updated. Thanks!

 

[Misca]

Looks like a macro is your only option unless you want to go manually through all the pivot tables on your worksheet and update them one by one.

Also, I've understood that it's not actually the pivot tables you're updating but you're refreshing the caches they're using. If you have two or more pivot tables using the same source data it's likely they're all using the same pivot cache. And when you refresh one of the tables all the other ones refresh as well.

 

[Alex Blakenburg]

You do know that all pivot tables using the same pivot cache will be refreshed when you refresh one of them right ?
This may work for you or against you. If all the pivots on the 1 sheet all use the same data set, they prompt you to use the same cache when you set it up and be refreshed at the same time. It can work against you if you have Pivots on other sheets that you don't want refreshed that also use the same data set & cache.
If the pivots on the one sheet use different sources, its likely only a macro will refresh those on that sheet without using refresh all.