View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dakotasteve dakotasteve is offline
external usenet poster
 
Posts: 10
Default copy pivot table and source from workbook 1 to 2.

When I copy a worksheet pivot table and its source worksheet from workbook 1
to workbook 2, the copies in workbook 2 appears to come across fine, but
when I update the source worksheet in workbook 2, and refresh the pivot table
in workbook 2, no update to the pivot table occurs. Is this just an "Oh
Well", or do any of you have a suggestion for a way to make this work? thx
so much!

--
DakotaSteve