Microsoft Excel Pivot tabel

pmv · #1 (**permalink**) 11-16-06, 13:55

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

shades · #2 (**permalink**) 11-16-06, 17:44

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?

pmv · #3 (**permalink**) 11-17-06, 03:37

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

shades · #4 (**permalink**) 11-17-06, 09:25

Is the Pivot Table toolbar showing? If so, click on the button on the far right.

pmv · #5 (**permalink**) 11-17-06, 09:34

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

shades · #6 (**permalink**) 11-17-06, 12:20

Try this code and see if it shows

Code:

Sub Macro1()
    ActiveWorkbook.ShowPivotTableFieldList = True
End Sub

pmv · #7 (**permalink**) 11-17-06, 13:50

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

shades · #8 (**permalink**) 11-17-06, 15:36

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!

Internet Services

Web Development

Digital Marketing

Consumer Tech