+ Reply to Thread
Results 1 to 2 of 2

Changing column name in source data for pivots

  1. #1
    Registered User
    Join Date
    04-09-2021
    Location
    Johannesburg
    MS-Off Ver
    MS 365
    Posts
    1

    Changing column name in source data for pivots

    Hi.

    I am not sure if this had been solved.

    My problem is the following:

    I have 2 sheets - 1. Source data with 40 columns and 10000 rows. 2. a pivot sheet which has 10 pivots linked to the source data sheet

    I need to change the source data columns (about 10 of them every month) as the months change (so do the columns names example from actual 2021 to May 2021 and so on).

    When the source data is updated and I refresh the pivots sheet it removes the pivot columns that were renamed.

    Any help on this.

    Thanks

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,910

    Re: Changing column name in source data for pivots

    Try creating dynamic named ranges, along the lines of

    =OFFSET(Data!$A:$AZ,,MATCH(J4,Data!$1:$1,FALSE)-1,,1)
    Bernie Deitrick
    Excel MVP 2000-2010

+ 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. Using 1 slicer for multiple pivots (diff data source)
    By Roskame in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-04-2015, 08:10 AM
  2. Replies: 0
    Last Post: 10-18-2013, 11:35 AM
  3. change source data for multiple pivots
    By gaevs75 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-09-2013, 06:17 AM
  4. Replies: 0
    Last Post: 11-03-2009, 10:22 AM
  5. Same Data source for Multiple Pivots
    By anandmr65 in forum Excel General
    Replies: 3
    Last Post: 07-07-2006, 07:47 AM
  6. programatically change the data source of Pivots
    By Help me in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-10-2005, 01:35 AM
  7. Anyone help with this error in changing data source of pivots
    By Job in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-02-2005, 06:20 PM

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