+ Reply to Thread
Results 1 to 3 of 3

Source columns not showing in Pivot fields

  1. #1
    Registered User
    Join Date
    02-01-2021
    Location
    Birmingham
    MS-Off Ver
    2016
    Posts
    27

    Source columns not showing in Pivot fields

    Hello everyone,
    I have recently added in a few columns to my source data table and am trying to make a new pivot table which includes these columns in the Values field. For some reason my new columns aren't showing up in the PivotTable Fields list even if I search for them. I have checked that the named source data table has updated to include these columns, which it has. I have also tried saving, closing and reopening my document to see if this updates it, however that didn't work.
    Has anyone come across this issue before? Any ideas on how to solve it?
    Thanks
    Last edited by lilybickel; 03-16-2021 at 12:25 PM.

  2. #2
    Registered User
    Join Date
    02-01-2021
    Location
    Birmingham
    MS-Off Ver
    2016
    Posts
    27

    Re: Source columns not showing in Pivot fields

    For anyone who's interested, simply right click on pivot table and press refresh

  3. #3
    Registered User
    Join Date
    04-02-2020
    Location
    North America
    MS-Off Ver
    360
    Posts
    1

    Thumbs up Re: Source columns not showing in Pivot fields

    FYI: My field list wasn't showing existing columns (not newly added ones). I did the refresh fix and it worked. Thanks!!!

+ 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. Replies: 3
    Last Post: 09-26-2020, 09:31 AM
  2. Replies: 5
    Last Post: 08-29-2018, 11:17 AM
  3. [SOLVED] My pivot table is not showing the same values as the source data
    By heytherejem in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 04-26-2018, 08:25 AM
  4. Replies: 4
    Last Post: 06-19-2014, 12:59 PM
  5. Replies: 3
    Last Post: 03-28-2014, 01:36 PM
  6. Replies: 1
    Last Post: 07-07-2011, 11:17 AM
  7. Pivot table fields not showing
    By ctenanthe in forum Excel General
    Replies: 2
    Last Post: 09-08-2010, 06:07 PM

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