Pivot Table(s)

[Roopen]

Hi All,

Hoping someone can help.. I have a spreadsheet that has about 5 pivots in one workbook... I am trying to find a way that if I change one of the pivots in the workbook the other pivots underneath will automatically refresh..

Is this possible or is there a macro that can do this?

Your help is always greatly appreciated

Roopen

 

[Xavier77]

Hi Roopen,

You can create a macro to refresh all tables simultaneously.

Simply start recording the macro, refresh all tables and stop recording was all tables have been completed.

Hope this helpls

Xavier

 

[Roopen]

Thank you Xavier... Works a treat !

 

[Weaver]

This might be more 'universal'

Sub refreshAllPivots()
    For Each ws In ActiveWorkbook.Worksheets
        For Each pt In ws.PivotTables
            pt.PivotCache.Refresh
        Next pt
    Next ws
End Sub

 

[Roopen]

Weaver,

This is more what I was after thank you so much... Saved me doing manual recording of a macro.

Roopen