+ Reply to Thread
Results 1 to 2 of 2

copy worksheets with Pivot tables embedded

  1. #1
    Registered User
    Join Date
    01-09-2009
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    1

    copy worksheets with Pivot tables embedded

    I have a single page worksheet with an embedded pivot table summarising the info on that page. The page needs to be updated weekly and printed with the management reports so I simply copy the worksheet, change the data and away we go. Catch is the new worksheet's pivot table still references the original worksheet.

    How can I get it to reference the new worksheet without running the pivot table wizard every time?

  2. #2
    Forum Contributor
    Join Date
    06-21-2005
    Location
    Cambridge, England
    Posts
    118
    You don't need to run the whole wizard again, if you click on the wizard, for a pivot table already existing the wizard goes directly to step 3, which is after the point where you enter the data range. If you click the back button (or back space) it will take you back to step 2 where you can change the data range to the current sheet.

    Would it be possible to save the whole workbook under a different name for each weeks data (whilst keeping your origial template) in order to avoid this problem all together?

    R

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1