PDA

View Full Version : Solved: Pivot table (XLD)



chungtinhlak
01-09-2009, 07:55 AM
xld, the code below, it gave me a compile error "Method or data member not found.


Dim sh As Worksheet

For Each sh In ActiveWorkbook.Worksheets

sh.RefreshAll
Next sh

Bob Phillips
01-09-2009, 07:59 AM
Sorry mate, that was clumsy. It is even easier than that



ActiveWorkbook.RefreshAll

chungtinhlak
01-09-2009, 08:13 AM
perfect, thanks, that worked. :)