Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pivot table refresh
No, you would us the workbook_Open event to execute the command
Worksheets("sheet1").PivotTables("PivotTable1").Re freshTable See Chip Pearson's page on Events for an explanation of the Workbook_Open event http://www.cpearson.com/excel/events.htm -- Regards, Tom Ogilvy "Valeria" wrote in message ... Dear experts, I would like to refresh a pivot table upon opening of the workbook where it's contained. I guess it must have something to do with the Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable) but I really can't figure out how I have to use this! Many thanks in advance. Kind regards, Valeria |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
slow document / pivot table refresh and pivot function | Excel Discussion (Misc queries) | |||
Create refresh button in worksheet to refresh Pivot Table Data | Excel Worksheet Functions | |||
refresh a new worsheet on pivot table refresh | Excel Worksheet Functions | |||
MY PIVOT TABLE WON'T REFRESH | Excel Discussion (Misc queries) | |||
Pivot Table REFRESH Flaw -- Saves Old Data in Selection Area AFTER REFRESH | Excel Programming |