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.
"Michelle" wrote:
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.
"Michael S" wrote:
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" wrote:
Hi Michael
Right click on the PT and from the dropdown select Show Field List
--
Regards
Roger Govier
"Michael S" <Michael wrote in message
...
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!