ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Pivot table field list missing (https://www.excelbanter.com/excel-worksheet-functions/261195-pivot-table-field-list-missing.html)

DianeG

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

Roger Govier[_8_]

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


DianeG

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

.


Herbert Seidenberg

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


Roger Govier[_8_]

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

.


DianeG

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

.



All times are GMT +1. The time now is 01:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com