Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi folks,
I've got a problem where in any new pivot table the drop down boxes for the field data no longer allow me to deselect anything. For example, I have data counted by time, grouped by month/year, and I want to turn off 2005 - I used to be able to do this, but I can no longer. I assume there's a global setting somewhere that I have inadvertently changed, but I can't find it! I've tried new pivot tables on new, very simple data with no luck. I've restarted PC also. Any thoughts? Cheers Aidan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table: Remove old field cell value | Excel Discussion (Misc queries) | |||
Pivot Table external XLS file source change and GETPIVOTDATA refresh | Excel Discussion (Misc queries) | |||
Conditional Formatting of Pivot Table Field | Excel Discussion (Misc queries) | |||
Pivot Table Comment Field | Excel Discussion (Misc queries) | |||
Pivot table page field switch to (all) if my criteria is not avail | Excel Discussion (Misc queries) |