+ Reply to Thread
Results 1 to 2 of 2

Multiple Pivot tables filter same data change template of all easy?

  1. 01-10-2013, 11:40 AM #1
    ThomasCarter
    ThomasCarter is offline
    Forum Contributor
    Join Date
    08-22-2012
    Location
    Newcastle, England
    MS-Off Ver
    Excel 2003
    Posts
    129

    Multiple Pivot tables filter same data change template of all easy?

    I have about 30 different pivot tables that filter a large mass of data

    When I want to make a change to the template of the pivot tables I have to do either of the following:

    Change every single pivot table manually.
    OR
    Change the first pivot table, delete the 29 other tables, copy the remaining one 29 times, change the worksheet name of all the copies manually, change the filter of each copy manually...

    Both are extremely time consuming, annoying, and prone to human error. Any suggestions to make it easier?
    Reply With QuoteRegister To Reply
  2. 01-10-2013, 11:49 AM #2
    MarvinP
    MarvinP is offline
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Multiple Pivot tables filter same data change template of all easy?

    Hi Thomas,

    I did this problem a while back. It has 3 pivot tables and changing the filter of any one of them is reflected on all 3 of them. See if it helps.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1