Pivot Table: Show Description instead Name

[Guest]

Hello,

I am using a PivotTable control (Excel.PivotTable). Do you know if
PivotTable control has a property to show the attributes' description and
dimension's Description in the cube instead its Name in the Field List
window???

I hope somebody can help me.

Thank you

 

[Norman Jones]

Hi Daniel,

Try something like:

'=============>>
Public Sub Tester()
With Range("A1")
.NumberFormat = "#,##0.00"
.Value = .Value
End With
End Sub
'<<=============

 

[Norman Jones]

Hi Daniel,

Please ignore my response, which was intended as the
reply to another thread!

 

[Guest]

Hello Norman,

The text that is displayed in the cells is right. That I need is to change
the Names that are displayed in the tree in "Field List" window. In this way
the user who generate the report would have names friendlier.

Thanks for answer

 

[Norman Jones]

Hi Daniel,

Please forgive me - my reply was intended as a response to the
chronologically adjacent thread: 'Text currency to number'!