Refresh all existing Pivot Tables in different Worksheets in a Workbook

Hello,

How can we Refresh all existing Pivot Tables in a Workbook? I have at least 4 Pivot Tables in 4 different Worksheets(one pivot on each Worksheet) in a Workbook, how can we update all at once?


I tried the following:

Please Login or Register  to view this content.

Does anybody have a better code to make that?



Thanks!

I think now I found a command to make that:

Please Login or Register  to view this content.

Does anybody make different than that? Any issues with above command that we need consider or can simply use that?

Thanks!