View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
PFB PFB is offline
external usenet poster
 
Posts: 12
Default Pivot table does not automatically update when underlying data cha

Excel 2007, Vista

How can I make the pivot table update automatically when the underlyng data
changes? (F9 doesn't force an update.) Also, how can I add more data to be
included in an existing pivot table wihout creating a new one?