1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel 2010 - No Pivot Table Field List

Discussion in 'Business Applications' started by bmaltz, Dec 20, 2012.

Thread Status:
Not open for further replies.
Advertisement
  1. bmaltz

    bmaltz Thread Starter

    Joined:
    Nov 18, 2006
    Messages:
    5
    Hi,

    I'm trying to set up a pivot table on some data and when I select the data and click on Insert Pivot Table, it opens a new sheet in my workbook for the new Pivot Table, but there is NO Field List to drag fields into the pivot table. And, yes, I do have the Pivot Table box on the left selected, but NO Field List.

    Thanks for the help
     

    Attached Files:

  2. draceplace

    draceplace

    Joined:
    Jun 8, 2001
    Messages:
    2,583
    Look on the far right of the ribbon (looking at your screen shot) Field List is there. You have to have focus on the pivot table.
     
  3. bmaltz

    bmaltz Thread Starter

    Joined:
    Nov 18, 2006
    Messages:
    5
    Hi, the screen shot shows that the active cell is in A6, which is inside the pivot table area. Yes, the ribbon does show that the Field List SHOULD be displayed, but it is NOT being displayed - that's the problem.
     
  4. draceplace

    draceplace

    Joined:
    Jun 8, 2001
    Messages:
    2,583
    Ok perhaps the settings have the field list 'detached' from the spread sheet. Play around with the restore/minimize, clicking on field list and see if the field list is hidding somewhere.
     
  5. bmaltz

    bmaltz Thread Starter

    Joined:
    Nov 18, 2006
    Messages:
    5
    that's a good idea, but when I tried it, still nothing. Assuming I was doing it properly:
    clicked into the pivot table, whcih SHOULD activate and display the Field List
    hit Ctrl-Space to bring up the window menu and selected Move
    used the arrow keys to try to move the window - the whole Excel window moved, NOT the Field List window
     
  6. draceplace

    draceplace

    Joined:
    Jun 8, 2001
    Messages:
    2,583
    I was talking about the the 'maximize' restore thing. Then minimizing resizing and clicking on the Field list button. If this must be done with short cuts. Field List: Alt+JT, L
     
  7. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1081764

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice