Solved: pivot tables

[chungtinhlak]

I have a bunch of pivot tables in my workbook in every sheets. is there a vba code to just refresh all the pivot table or do i just have to do it to each indivual one when I update my data?

thanks

[Bob Phillips]

[vba]

Dim sh As Worksheet

For Each sh In ActiveWorkbook.Worksheets

sh.RefreshAll
Next sh
[/vba]

[chungtinhlak]

thank you