Hi,

I need a macro which will update my Pivot Tables in the whole workbook in a very specific order.
Refresh All function doesn't do the trick as some pivot tables depend on data summarized in another one.
So let's say I have 3 worksheets and each contains one pivot table (Sheet1 with Pivot1; Sheet2 with Pivot2; Sheet3 with Pivot3)
I would need a macro which will update pivot tables in the following order: Pivot3-->Pivot1--->Pivot2.
Any ideas how I can do it?
I tried recording a macro with manual updates, but the screen jumping between workseets is driving me mad...

Many thanks in advance for your help.