Where has my field list gone for my Pivot Tables?

M

Michael S

Hi, I am trying to create Pivot Tables but I can no longer show my field list
and therefore cannot use the Pivot Table functionality!
I am not sure whether I have changed a setting as this worked previously!
 
R

Roger Govier

Hi Michael

Right click on the PT and from the dropdown select Show Field List
 
M

Michael S

Unfortunately that doesn't seem to work either, I have tried all the standard
stuff and posted on a few other forums. I am thinking I will have to
reinstall Excel!
 
R

Roger Govier

Hi Michael
I am thinking I will have to reinstall Excel!
Click to expand...

Before you go to those lengths, if you want to mail a copy of the file
direct to me, I would be quite happy to see if I can see what the
problem is.
To mail direct remove NOSPAM from my email address.
 
M

Michelle

Michael - Did you ever resolve this issue? I'm having the same problem and
I'm hoping I don't have to reinstall the program.
 
B

brad

Anybody ever figure this out? It seems to happen to me occassionally when I
save the file all of the pivot tables get range valued and cannot be modified
anymore. I only started getting this problem when I switched over to Excel
2007.
 
Top