If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pivot table field list missing
I'm using 2007 and have created several pivot tables from this particular
database but now, suddenly when I create a pivot table from scratch, the field list is not displayed although the show/hide buttons on the ribbon are lit up. My active cell is inside the table, what have I done wrong??? Regards Diane |
#2
|
|||
|
|||
Pivot table field list missing
Hi Diane
Options tabField List -- Regards Roger Govier Dianeg wrote: I'm using 2007 and have created several pivot tables from this particular database but now, suddenly when I create a pivot table from scratch, the field list is not displayed although the show/hide buttons on the ribbon are lit up. My active cell is inside the table, what have I done wrong??? Regards Diane |
#3
|
|||
|
|||
Pivot table field list missing
Hi Roger
Thanks for the response but that's what's strange about this, the field list button is active, in fact all of the buttons on the show/Hide group are active I've never seen that before without the field list being displayed. Any other ideas? Thank you Diane "Roger Govier" wrote: Hi Diane Options tabField List -- Regards Roger Govier Dianeg wrote: I'm using 2007 and have created several pivot tables from this particular database but now, suddenly when I create a pivot table from scratch, the field list is not displayed although the show/hide buttons on the ribbon are lit up. My active cell is inside the table, what have I done wrong??? Regards Diane . |
#4
|
|||
|
|||
Pivot table field list missing
Excel 2007 PivotTable Field List
Could be hiding at the bottom: http://www.mediafire.com/file/zzwi2g5yz3q/04_10_10a.pdf |
#5
|
|||
|
|||
Pivot table field list missing
Hi Diane
If Herbert's suggestion doesn't bring any joy, you can send me a copy of the file and I will take a look. To send direct roger at technology4u dot co dot uk Change the at and dots to make valid email address -- Regards Roger Govier Dianeg wrote: Hi Roger Thanks for the response but that's what's strange about this, the field list button is active, in fact all of the buttons on the show/Hide group are active I've never seen that before without the field list being displayed. Any other ideas? Thank you Diane "Roger Govier" wrote: Hi Diane Options tabField List -- Regards Roger Govier Dianeg wrote: I'm using 2007 and have created several pivot tables from this particular database but now, suddenly when I create a pivot table from scratch, the field list is not displayed although the show/hide buttons on the ribbon are lit up. My active cell is inside the table, what have I done wrong??? Regards Diane . |
#6
|
|||
|
|||
Pivot table field list missing
Thanks very much, it wasn't hidden on the bottom, but on the side! I've
never seen that before I need the pivot table for a job presentation tomorrow so you've saved my bacon! Thanks again Diane "Herbert Seidenberg" wrote: Excel 2007 PivotTable Field List Could be hiding at the bottom: http://www.mediafire.com/file/zzwi2g5yz3q/04_10_10a.pdf . |
Thread Tools | |
Display Modes | |
|
|