Pivot Table Field List

**sachinattri** · 01-05-2010, 05:59 AM

Hi,

I am not able to see my Field List in the Pivot Table. I have done the Show/Hide Field List but it just doesnt show up.

Can you advise on what could be the possible reason?

Thank you very much

Sachin

**JimmyA** · 01-05-2010, 06:03 AM

Hello

Just googled this, a few people are saying it might be to do with what view you are using.

Are you in Full Screen View. if so try taking it out of that and trying again. or save the workbook, close and reopen.

Hope this helps

Cheers

Jim

**sachinattri** · 01-05-2010, 06:48 AM

No it doesnt work

I am in the Normal view only. Changed and re opened the file. Same thing, cant see the Field List. Am using Excel 2003.

Help !!!!

**JimmyA** · 01-05-2010, 07:26 AM

Just found this...........

In frustration I carried on clicking the hide and show field
list button and noticed a line appearing in the right hand corner of my
screen each time I clicked to show the field list. This line was actually the
field list box, which had virtually disappeared off the screen (I think due
to changing screen resolution when switching between using laptop screen and
a monitor). I clicked on the line and was able to drag the field list back on
to the screen.

I have a simalar problem with using "find" in VBA. Hope this helps. Other than this I'm fresh out of ideas sorry.

Jim