View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CrimsonPlague29 CrimsonPlague29 is offline
external usenet poster
 
Posts: 18
Default Pivot Tables-Source Range continually increasing

HI,

I have a set of data that is added to on regular basis, how can I
automatically capture the new data in my pivot table by just refreshing
table, without having to go and highlight the range each time .....

Thanks
Crimson