Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic refresh of pivot tables
I am looking for an automatic procedure to open a file (excel 2003), refresh
all pivot tables (olap cubes) and save it. thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic refresh of pivot tables
Hi
Sub OpenUpdatePivotTablesSave() Dim pt As PivotTable Dim ws As Worksheet Dim wb As Workbook Set wb = Workbooks.Open("C:\Myfile.xls") For Each ws In wb.Worksheets For Each pt In ws.PivotTables pt.RefreshTable Next pt Next ws wb.Save End Sub -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Dan" wrote: I am looking for an automatic procedure to open a file (excel 2003), refresh all pivot tables (olap cubes) and save it. thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic refresh of pivot tables
Thanks Wigi. it works
"Wigi" wrote: Hi Sub OpenUpdatePivotTablesSave() Dim pt As PivotTable Dim ws As Worksheet Dim wb As Workbook Set wb = Workbooks.Open("C:\Myfile.xls") For Each ws In wb.Worksheets For Each pt In ws.PivotTables pt.RefreshTable Next pt Next ws wb.Save End Sub -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Dan" wrote: I am looking for an automatic procedure to open a file (excel 2003), refresh all pivot tables (olap cubes) and save it. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot Refresh Pivot Tables | Excel Worksheet Functions | |||
Pivot Tables Refresh | Excel Discussion (Misc queries) | |||
Excel Pivot tables refresh | Excel Worksheet Functions | |||
Refresh all pivot tables in a workbook | Excel Discussion (Misc queries) | |||
refresh pivot tables through a macro | Excel Worksheet Functions |