Field list not showing up

  • Thread starter Thread starter JeffVA
  • Start date Start date
J

JeffVA

Excel 2007...no matter what I do the field list does not show up. when I
select hide the pivot table frame goes blank, when I unhide I get the basic
table verbiage, but no field list.

Any thoughts?
 
Actually when I go to fullpage view I can get the field list, but in normal
view cannot get the field list to appear.

driving me nuts.
 
Hi,

This question is unclear. What do you mean by "hide the pivot table
frame". Pivot tables don't have frames, so what are we talking about.

Regarding the PivotTable Field List - you can display this in many layout by
opening the drop-down button on the top right of the PTFL and choosing the
display you want.
 
Although I can't duplicate your problem by just hiding/unhiding the PTFL, I
can cause a problem if I use Full Screen view. There may very well be a
problem here. If I don't use the Full Screen view the PTFL seems to work ok
in the spreadsheet. You can also close and reopen Excel. This worked on my
machine but closing the file left the PTFL displayed on screen even though no
PT was open.
 
Hey,

What I am referring to is when you insert a pivot table the outline that
shows up on the left hand side of the spreadsheet that says "to build a
report, choose fields from the pivot table field list'.

I have tried numerous times to use the Field List button at the top right
of the pivottable tools ribbon..no luck. As I said, when I go to Full page
view, ithe field list is there for use, when I restore to a Normal view the
"frame" remains but no Field List. I have rebooted, tried new data sets to
pivot...nothing.

Odd thing is that when I first loaded it, worked fine...then one AM this
occurred. Driving me nut going back and forth from full to normal screen.

Any ideas?

Jef
 
I have the same problem except the field list does not show up in Full
Screen. Searched other sources. Found several people who said removing and
reinstalling Office did not work. Found one who said removing Office and
deleting the Excel folders in Documents & Settings before reinstalling did
work. I tried it. It worked. I closed and opened Excel and the file three
times without problems. Then, I worked on another file. Think it was xlsb
format. Now the problem is back.
 
I have the same problem except thefieldlistdoes not show up in Full
Screen.  Searched other sources.  Found several people who said removing and
reinstalling Office did not work.  Found one who said removing Office and
deleting the Excel folders in Documents & Settings before reinstalling did
work.  I tried it.  It worked.  I closed and opened Excel and the file three
times without problems.  Then, I worked on another file.  Think it was xlsb
format.  Now the problem is back.
Click to expand...

This has worked for me. I removed the following files;

(Back up these files before deleting)

- C:\Documents and Settings\user\Application Data\Microsoft\Office
\Excel12.*
- C:\Documents and Settings\user\Application Data\Microsoft\Excel\*.*

I think excel's office setting file(s) get corrupted somehow, I am not
sure what is causing this. In anycase if I find out why this is
happening I will post it in this post here.

Hope this helps.
 
I deleted just C:\Documents and Settings\user\Application
Data\Microsoft\Excel\Excel12.xlb. It fixed the problem. Thanks.
 
Back
Top