Excel 2007 Pivot Table Field List vanished

[mdjks]

I am working with pivot tables in Excel 2007 and my field list does not appear on screen. If I click the icon to show/hide field list it toggles but the only thing that changes on screen is the words within the pivot frame such as "drop data here" disappear.

I have two machines and this is only happening on the laptop. I've tried the same file on both, leaving the field list visible on save, it is gone on second machine. I've tried to check that all setting are the same and have tried rebooting.

Has this happened to anyone else? Any suggestions would be appreciated.

 

[bpullon]

I was just using someone else's laptop and had something similar happen, check that it's not just off screen, ie been moved so you can't see the window.

 

[mdjks]

Checking to see if it had just moved off screen was one of my first checks, maybe it did but I looked everywhere. I uninstalled office 2007, rebooted, reinstalled and rebooted again. The field list was still missing. I checked settings on another computer, looking for any differences and the only one I found was the default file type on the computer that the field list was missing on had been set to xlsm. I changed that to xlsx and still no list.

I called our IT help desk and just as they remoted in to look at the desk top the field list reappeared. I have to chock it up to coincidence but the remote connection was the only other variable.

Really strange, maybe a computer poltergeist.

 

[ravishankars]

Got the same error. PivotTableFields were missing. But when Excel started in save mode (press Ctrl key during startup), the settings appeared.

Solution: Found that the Excel12.xlb (the toolbar items in Addin tab) were loaded twice once from user folder & once again from startup folder. The error was resolved when i deleted the copy in the alternate startup path