LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Pivot Table: Copy from one Book to another

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table formula cell copy Rgmacdee Excel Discussion (Misc queries) 1 November 27th 06 10:11 PM
Is there a way to copy a pivot table using a different data set? UPe Excel Discussion (Misc queries) 2 April 21st 06 04:52 PM
Copy pivot table and get rid of connection araki Excel Discussion (Misc queries) 3 March 8th 06 12:59 AM
Pivot table copy and paste yllee70 Excel Worksheet Functions 0 February 23rd 05 07:39 AM
copy/paste pivot table Todd L. Excel Worksheet Functions 0 December 30th 04 04:11 PM


All times are GMT +1. The time now is 06:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"