View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Michael B[_2_] Michael B[_2_] is offline
external usenet poster
 
Posts: 1
Default Pivot tables and replacing data, then refresh it

Hi
I have a template file that I made in excel using pivot tables, it has
multiple tabs and only one tab with the data.

How can I bring in the new data and refresh all 3 of the tabs with the pivot
tables?

Anything automatic that I can do once I put the data in? If there is
something on a tool bar, pls help me find it. Some times the replacing data
may be smaller or larger than the data it will be replacing.

Thanks