I have two sets of pivot tables that are currently in two different Excel
books. I copied the sheets including pivot table and source data sheets from
Book A to Book B, but when I tried to refresh the data for the tables now in
Book B, an error message appeared stating that the data [from Book A] could
not be found. Any suggestions of how to copy pivot tables from one book to
another would be quite helpful. Thanks.