Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Missing Field List | Excel Discussion (Misc queries) | |||
Pivot Table Field List Missing | Excel Discussion (Misc queries) | |||
Pivot table field missing | Excel Worksheet Functions | |||
Pivot table field list missing | Excel Discussion (Misc queries) | |||
Missing Grand Total for a Calculated Field in a Pivot Table | Excel Worksheet Functions |