Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't deselect drop down field in a pivot table
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't deselect drop down field in a pivot table
Hi,
Thanks to Debra, here is the macro I use to get rid of Unsused items .... Sub DeleteOldItems() Dim ws As Worksheet Dim pt As PivotTable Dim pf As PivotField Dim pi As PivotItem On Error Resume Next For Each ws In ActiveWorkbook.Worksheets For Each pt In ws.PivotTables pt.RefreshTable pt.ManualUpdate = True For Each pf In pt.VisibleFields If pf.Name < "Data" Then For Each pi In pf.PivotItems If pi.RecordCount = 0 And _ Not pi.IsCalculated Then pi.Delete End If Next pi End If Next pf pt.ManualUpdate = False pt.RefreshTable Next pt Next ws End Sub HTH Cheers Carim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |