| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table
Bob
In code a line similar to ActiveSheet.PivotTables("PivotTable1").PivotCache. Refresh In GUI, press the ! button on the pivot table toolbar. You can check the pivottable 'table options', by right clicking on a cell. This way you may be able to set 'Refresh on open, or refresh in x minutes, other than that it will not refresh automatically, although via event code it could be made to. Check out the above code line or GUI options and post back if you require Event code -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Bob" wrote in message ... I am new into Excel... I have created a Pivot Table on Sheet4 and the source of data on sheet1.When I update Sheet1, Pivot table dosen't refresh.How can I refresh the Pivot Table with the new data? Thank you. Bob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| Pivot Table and Pivot Table dates are not in correct order | Charts and Charting in Excel | |||
| Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
| Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
| Help required with setting up a pivot table with the source on sheet1 to have the pivot table created on sheet called "report" | Excel Programming | |||
Threaded Mode
