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.

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.

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.