[rruzgas]

I have windows vista home premium and Office Excel 2007 Professional Plus edition. When I select a range of table to make a pivot table , a blank table appears and no Field List menu appears... have tried to make it appear by clicking Toggle button of show field list but it do not respond... have tried to uninstalling and reinstalling Excel but to no avail..I have noted that a lot of buttons on ribbon on pivot table menu ribbon do not appear to respond ... why is this so.. PLEASE help

[Zack Barresse]

Hi there, welcome to the board!

You must have your Pivot Table selected in order to see the Field List. If it does not appear, try selecting any cell where the Pivot Table is located, click on the contextual Options menu tab under PivotTable Tools, and in the Show/Hide group you'll see a large toggle button labeled Field List. Ensure that is toggled on.

[rruzgas]

Thank you!...
That wasn't the problem. But it was a user issue. Two users share a PC for reporting and one of them moved the PivotTable list all the way to the bottom of the excel spreadsheet. The other user logged in and couldn't see it. I asked them to send me a screen shot and I saw the PivotTable list all the way in the corner at the bottom of the screen. You couldn't really see the table, just the drop down arrow for Task Pane options. Can't fool proof the system :-)

[Zack Barresse]

No, that you can't! You can mark your thread Solved though, by going to Thread Tools | Mark Solved | Perform Action.