+ Reply to Thread
Results 1 to 4 of 4

Show field list in PT is blank (N/A)

  1. #1
    Registered User
    Join Date
    12-01-2022
    Location
    Slovenia
    MS-Off Ver
    2016, 365
    Posts
    12

    Show field list in PT is blank (N/A)

    Hello there.

    I have forgot how, but days ago I managed to show pivot table only as a normal table, without signs that this is pivot. Now I'd like to add another filter into it and got stuck: in menu "Analyze" icon "show field list" is blank / not available. Same happens at right click on the table - no luck.

    What have I done wrong? How can I manage PV again?

    Thanks.

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,913

    Re: Show field list in PT is blank (N/A)

    If it's no longer a pivot table, you will have to recreate it from scratch to make it one again.
    Rory

  3. #3
    Registered User
    Join Date
    12-01-2022
    Location
    Slovenia
    MS-Off Ver
    2016, 365
    Posts
    12

    Re: Show field list in PT is blank (N/A)

    Well, I did not change it as normal table.

    I just "removed" the look of pivot table. Everything still works fine (refresh data etc) and also if I want to, I can easily turn on Field Headers and choose only selected data and so on.
    Therefore I belive my table is still pivot, it's just something I need to turn back on if I want to modify it.

    But I don't know where is that icon or something... :-)

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,913

    Re: Show field list in PT is blank (N/A)

    If it’s still a pivot table there should be a show field list option when you right-click it.

+ 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] Getting ISBLANK to show either blank field or WORKDAY result
    By Landerolin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-29-2018, 07:38 AM
  2. [SOLVED] Pivot to show only Non-Zero/blank field and total for Column
    By jp16 in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 08-29-2017, 08:27 AM
  3. Replies: 1
    Last Post: 11-03-2013, 02:58 PM
  4. Replies: 1
    Last Post: 05-25-2008, 06:28 AM
  5. Show field list does not appear
    By KonaAl in forum Excel General
    Replies: 1
    Last Post: 06-20-2006, 06:20 PM
  6. [SOLVED] My pivot table field list show duplicates
    By Kay in forum Excel General
    Replies: 0
    Last Post: 12-06-2005, 05:55 PM
  7. How can I show all field data in a pivot table, instead of blank
    By Alastair Scott in forum Excel General
    Replies: 3
    Last Post: 08-17-2005, 03:05 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