Results 1 to 8 of 8
  1. #1
    Join Date
    Nov 2006
    Posts
    4

    Unanswered: Microsoft Excel Pivot tabel

    I have lost the field-list when I create a pivot-tabel.
    When i press button : 'show file list' the field-list does not show.

    What to do.

    mvh
    pmv

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy. Welcome to the board.

    Is the active cell in the Pivot Table when you try to activate the Field List?

    What version of XL are you using?
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Nov 2006
    Posts
    4
    I am using excel 2003, The cells are active, But there are no fields I can drop in the pivot-tabel. They are missing.

    pmv

  4. #4
    Join Date
    Oct 2003
    Posts
    1,091
    Is the Pivot Table toolbar showing? If so, click on the button on the far right.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  5. #5
    Join Date
    Nov 2006
    Posts
    4

    Red face

    Yes it is showing. And the button 'Hide-Field-List' is showing
    When I press 'Hide-Field-List'
    I can press 'Show-Field-List'

    But I still miss the Field-List

    pmv

  6. #6
    Join Date
    Oct 2003
    Posts
    1,091
    Try this code and see if it shows

    Code:
    Sub Macro1()
        ActiveWorkbook.ShowPivotTableFieldList = True
    End Sub
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  7. #7
    Join Date
    Nov 2006
    Posts
    4
    Did not help.
    Or I do not know if I am running it correct.
    Please instuct.

    I am from Norway, so if my English is not correct - that's why.

    pmv

  8. #8
    Join Date
    Oct 2003
    Posts
    1,091
    While in Excel, press ALT + F11 [key]. This will bring up the VBE window. On the left is the Project Explorer window (similar to Windows Explorer). If you cannot see it, then hit CTRL + R. Find your workbook in the project list and double-click it, select the Wiorkbook, then go to menu, Insert > Module. A window will appear on the right side of the screen. Paste the code into the window. Then use the key F5 to run the code. Go back to Excel to see if the Field List is visible.

    BTW, your English is just fine!
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •