We have users using Pivot Tables that would like to create Excel reports,
showing all members for a dimension, even if they do not have any values
associated with.

The option "Show items with no data" ckeck box isn´t available to select, is
there any reason for this ?

this option can´t be used with olap cubes ?

Is it necessary to change something in the cube, or dimensions for making
this available.

Thanks in advance

'You can try these macros:

Sub CheckSetting()

' You can check the display setting for empty columns and empty rows

Dim pvtTable As PivotTable

Set pvtTable = ActiveSheet.PivotTables(1)

' Determine display setting for empty columns.
If pvtTable.DisplayEmptyColumn = False Then
MsgBox "Empty columns will not be displayed."
Else
MsgBox "Empty columns will be displayed."
End If

' Determine display setting for empty rows.
If pvtTable.DisplayEmptyRow = False Then
MsgBox "Empty rows will not be displayed."
Else
MsgBox "Empty rows will be displayed."
End If

End Sub

Sub SetEmptyRows()

' 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

End Sub

"Rodrigo Santos" wrote: