+ Reply to Thread
Results 1 to 2 of 2

Pivot table refearring to previous column name

  1. #1
    Registered User
    Join Date
    11-09-2020
    Location
    Latvia
    MS-Off Ver
    MS Excel 2016
    Posts
    1

    Pivot table refearring to previous column name

    Hello,

    I have a one data source table and several pivots referring to it. I cannot refresh those, get the error that column names are not valid, even though there are names fo all colums, no hiddeen colums etc. I see that in Pivot table field list for one of colums, heather shows blank (even there is name in source field). In other pivot tables prevouos name for this column is shown (one that is not in source table anymore, such word combination does not exist in this worksbook anymore. Due to this I cannot refresh data in any of pivot tables.

    I have not used field names, have tried to redefine source data (not possible due to "name not valid" error). Even the if the column, whose name shows differently on pivot tables, is delated, it still shows in pivot table field list, still with different names for different pivot tables (in that case data range shows that this field is no longer in range).

    Please help me to solve this, I have no idea on what to try next and how to proceed.

    Thanks in advance

  2. #2
    Registered User
    Join Date
    11-02-2020
    Location
    Paris, France
    MS-Off Ver
    Professional Plus 2013
    Posts
    41

    Re: Pivot table refearring to previous column name

    Hi,

    If you could send an excerpt of the file, without any sensitive data in it, we could probably help.
    Because although we offer help virtually, we need to have our hands on something to help

    Cheers.
    ⭹ If this helped you, please add reputation

+ 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. [SOLVED] Calculate increase from previous raw in Pivot Table
    By gexcellermo in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-29-2020, 10:22 AM
  2. Replies: 6
    Last Post: 01-24-2017, 06:56 PM
  3. Replies: 0
    Last Post: 02-25-2015, 01:02 PM
  4. Pivot table remains linked to table on previous worksheet
    By shmir in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 02-04-2015, 04:46 PM
  5. 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
  6. Pivot Table | Use previous value in calculated item
    By carlyman in forum Excel General
    Replies: 1
    Last Post: 08-03-2011, 08:51 AM
  7. Pivot Table not deleting previous data?
    By Vickii in forum Excel General
    Replies: 4
    Last Post: 09-14-2009, 03:45 AM

Tags for this Thread

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