2007 Pvt Group/Ungroup symbols

[LindaSD]

In 2007 pivot tables have a symbol showing (minus & plus signs) to group and
ungroup data. Prior version all I did was double click to perform this task.
Can these symbols be turned off so they don't show? It is very difficult to
visually review large amouts of data with these gray symbol boxes stuck in
every column. Also I now have to print preview to see if the column prints
because on the normal view the column setting is taking up space to show
these symbols. When I go to print preview I have to adjust my column widths
again. These may be nice to someone who never used a pivot table but they
are in the way. Thanks for any help.

 

[Roger Govier]

Hi Linda

Right click on PT>Table Options>Display>Deselect show expand/collapse
buttons

 

[LindaSD]

Works, thanks. But it only works on each individual pvt tbl. Is there a way
to set a Excel default so the only way it appear is if I turn it on? I've
looked but don't see it.
2007 has me feeling like I'm starting all over again.

 

[Roger Govier]

Hi Linda

There isn't a workbook setting for this as far as I am aware.

You could use the following code to turn off indicators in all PT's in the
workbook.

Sub TurnOffDrillIndicators()
Dim pt As PivotTable, ws As Worksheet
Application.EnableEvents = False
Application.ScreenUpdating = False
On Error Resume Next
For Each ws In ActiveWorkbook.Worksheets
If ws.PivotTables.Count > 0 Then
For Each pt In ws.PivotTables
ws.PivotTables(1).ShowDrillIndicators = False
Next pt
End If
Next ws
On Error GoTo 0
Application.EnableEvents = True
Application.ScreenUpdating = True
End Sub

Copy the Code above
Alt+F11 to invoke the VB Editor
Insert>Module
Paste code into white pane that appears
Alt+F11 to return to Excel

To use
Alt+F8 to bring up Macros
Highlight the macro name
Run