PDA

View Full Version : Solved: pivot tables



chungtinhlak
01-08-2009, 03:06 PM
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
01-08-2009, 03:16 PM
Dim sh As Worksheet

For Each sh In ActiveWorkbook.Worksheets

sh.RefreshAll
Next sh

chungtinhlak
01-08-2009, 04:16 PM
thank you