Hello!
I want to create calculated member in my Pivot Table (connected to
SSAS'2005) programmatically. I use

..PivotTables(1).CalculatedMembers.Add

But .Add method have only two parameters: name of calculated member and MDX
expression to calculate it. How can I specify format string, color expression
and other parameters of calculated member? Also, I found a strange behavior
of Excel'2007: I can't find my calculated member if it is bound not to
Measures dimension except I specify [All] node of dimensions hierarchy
explicitly:

When I call

pvt.CalculatedMembers.Add "[Date].[Year].MyMember", "..."

I can't find MyMember nowhere in Pivot Table interface. But when I call

pvt.CalculatedMembers.Add "[Date].[Year].[All].MyMember", "..." - it is
there, among normal members of a hierarchy...