Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
While using a pivot table..
I used to be able to add a field when i double clicked it in the Field List pop up window to whatever section was selected in the "Add To" drop down, however I have lost that ability and was wondering if anyone out there knew how to get it back. Thanks in advance |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is this a problem in all pivot tables, or just one?
What version of Excel are you using? AK wrote: While using a pivot table.. I used to be able to add a field when i double clicked it in the Field List pop up window to whatever section was selected in the "Add To" drop down, however I have lost that ability and was wondering if anyone out there knew how to get it back. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
It seems to affect all pivot tables
I'm using Excel 2003 Thanks "Debra Dalgleish" wrote: Is this a problem in all pivot tables, or just one? What version of Excel are you using? AK wrote: While using a pivot table.. I used to be able to add a field when i double clicked it in the Field List pop up window to whatever section was selected in the "Add To" drop down, however I have lost that ability and was wondering if anyone out there knew how to get it back. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Does everything else work as expected?
Can you add fields to the pivot table by using the Add button in the field list? AK wrote: It seems to affect all pivot tables I'm using Excel 2003 Thanks "Debra Dalgleish" wrote: Is this a problem in all pivot tables, or just one? What version of Excel are you using? AK wrote: While using a pivot table.. I used to be able to add a field when i double clicked it in the Field List pop up window to whatever section was selected in the "Add To" drop down, however I have lost that ability and was wondering if anyone out there knew how to get it back. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Overwrite field item name in a Pivot table | Excel Discussion (Misc queries) | |||
Pivot Table external XLS file source change and GETPIVOTDATA refresh | Excel Discussion (Misc queries) | |||
Pivot Table Page Field Area Broken | Excel Discussion (Misc queries) | |||
How can I show all field data in a pivot table, instead of blank | Excel Discussion (Misc queries) | |||
Pivot Table Data Field Query | Excel Worksheet Functions |