View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DianeG DianeG is offline
external usenet poster
 
Posts: 59
Default How do updates work when creating a pivot table based on another?

I've never quite got how this works. If I create a pivot table based on
another, does it matter which one I base it on?

Also If I update the main data source do I have to go to each pivot table
and update each one manually - or if one is updated do all the others based
on it update too?

Thanks

Diane