in reply to Creating Pivot tables from Perl
Sub Auto_Open() Application.OnSheetActivate = "UpdateIt" End Sub Sub UpdateIt() Dim iP As Integer Application.DisplayAlerts = False For iP = 1 To ActiveSheet.PivotTables.Count ActiveSheet.PivotTables(iP).RefreshTable Next Application.DisplayAlerts = True End Sub
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re^2: Creating Pivot tables from Perl
by narashima (Beadle) on Nov 08, 2005 at 20:39 UTC |