Pivot Table "Show All" Check Box missing in Excel 2000
 

Dear All,

I am facing the same problem and hope soneone can provide the method to
display the "Show All" checkbox.

Thanks and best regards,
Owen Liu :confused:


--
OwenLiu
------------------------------------------------------------------------
OwenLiu's Profile: http://www.excelforum.com/member.php...o&userid=16212
View this thread: http://www.excelforum.com/showthread...hreadid=216876

Are you using an OLAP cube as your data source? You won't have that selection
available to you if you are. Here is some code that will do it.

Public Sub showAll()
On Error GoTo err_CmdShow:


' You can set the display setting for empty columns and empty rows that
'will be displayed

Dim pvtTable As PivotTable
Set pvtTable = ActiveSheet.PivotTables(1)
' Empty rows will be displayed
pvtTable.DisplayEmptyRow = True
'Empty columns will be displayed.
pvtTable.DisplayEmptyColumn = True

err_GetOut:
Exit Sub

err_CmdShow:
MsgBox Err.Description
GoTo err_GetOut
End Sub


"OwenLiu" wrote:


Dear All,

I am facing the same problem and hope soneone can provide the method to
display the "Show All" checkbox.

Thanks and best regards,
Owen Liu :confused:


--
OwenLiu
------------------------------------------------------------------------
OwenLiu's Profile: http://www.excelforum.com/member.php...o&userid=16212
View this thread: http://www.excelforum.com/showthread...hreadid=216876

If you're using Excel 2000, or an earlier version, the Show All checkbox
isn't available. You can use a macro to hide or show the items --
there's some sample code on my web site:

http://www.contextures.com/xlPivot03.html

OwenLiu wrote:
I am facing the same problem and hope soneone can provide the method to
display the "Show All" checkbox.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html