Pivot Table

B

Bob

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
 
N

Nick Hodge

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
[email protected]
 
Top