+ Reply to Thread
Results 1 to 7 of 7

Pivot table remains linked to table on previous worksheet

  1. #1
    Registered User
    Join Date
    01-26-2015
    Location
    quebec, canada
    MS-Off Ver
    2007
    Posts
    6

    Pivot table remains linked to table on previous worksheet

    I have a workbook with several sheets. On each sheet I have a Pivot table and a regular table with data in it.
    I would like to copy the table and the pivot table to create a new worksheet without having to relink the data source each time.
    Thanks in advance!

  2. #2
    Forum Contributor
    Join Date
    09-11-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2003, Excel 2007, Excel 2013
    Posts
    103

    Re: Pivot table remains linked to table on previous worksheet

    You may consider to,
    1) When moving the table to new worksheet. CTRL+Select the data file and move together
    2) Copy and paste the data in new worksheet, then create the pivot table
    Click * to reward me...
    Thank you...

  3. #3
    Registered User
    Join Date
    01-26-2015
    Location
    quebec, canada
    MS-Off Ver
    2007
    Posts
    6

    Re: Pivot table remains linked to table on previous worksheet

    sorry but it wont work.
    I cant redo the pivot table each time. I need a automatic way to copy the whole data and have the new pivot table linked to the new chart. the problem is that I cant make the table worksheet scoped.

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Pivot table remains linked to table on previous worksheet

    What is the reason for copying the same data and make a new pivot table.

    Why not work in 1 worksheet and refresh the pivot table?
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  5. #5
    Registered User
    Join Date
    01-26-2015
    Location
    quebec, canada
    MS-Off Ver
    2007
    Posts
    6

    Re: Pivot table remains linked to table on previous worksheet

    I need weekly data. Every week I need a new chart and a new pivot table. Iwant to create a blank sheet and copy in and rename it every week

  6. #6
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Pivot table remains linked to table on previous worksheet

    Yes, that is what you want.

    My advice would be, make 1 sheet with all weeks in it.

    Make 1 column that defines the weeknumber.

    Then you only have to refresh the pivot table.

  7. #7
    Registered User
    Join Date
    01-26-2015
    Location
    quebec, canada
    MS-Off Ver
    2007
    Posts
    6

    Re: Pivot table remains linked to table on previous worksheet

    it wont work because I need an automatic way to be able to copy a full page and not need to refresh it each time. My problem is that I cant make my chart worksheet scoped.
    thank you for trying to help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. AVG of previous 6 columns in Pivot Table
    By ARayburn in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-01-2013, 10:04 AM
  2. Drill Down Updates from a Pivot Table linked to a table
    By BON1985 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-21-2012, 10:18 AM
  3. Excel 2007 : Pivot table % of previous month query
    By SteveW68 in forum Excel General
    Replies: 1
    Last Post: 04-08-2010, 02:18 PM
  4. Pivot Table not deleting previous data?
    By Vickii in forum Excel General
    Replies: 4
    Last Post: 09-14-2009, 03:45 AM
  5. Replies: 0
    Last Post: 08-08-2005, 03:05 AM

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