Figured it out. It must be an Excel 07 glitch. The Fields list disappears and the Field List button on the ribbon does nothing. I even tried closing and reopening workbook and another where I have Pivot tables.
I resolved it simply by closing down excel the reopening it. That did the trick.