Where has my field list gone for my Pivot Tables?

[Guest]

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!

 

[Roger Govier]

Hi Michael

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

 

[Guest]

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!

 

[Roger Govier]

Hi Michael

I am thinking I will have to reinstall Excel!

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.

 

[Guest]

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.

 

[Guest]

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.