View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
evoxfan evoxfan is offline
external usenet poster
 
Posts: 65
Default Pivot Table Data Source

I have a pivot table already created; the data source is the next worksheet.

Since then I added some data outside the data source by addicg some rows of
data to the bottom of the data source.

Can the data source for the existing pivot table be change to include these
added rows (if so, how) or do I need to delete this pivot table and create a
new pivot table via the wizard to include all new data?

Thanks in advance for help.