Hello Dmitry,

I am still dicussing the issue with the product team members. The change
that the calculated members are greyed is introduced by SQL Server 2005
SP2. Based on our test, the calculated members can be partially selected in
Excel 2007 without SQL Server 2005 SP2. According to the notes logged by
the Excel product team when they design&developed Excel 2007, it is by
design to grey the calculated members. I am asking for the reason, and
trying to find workarounds for you. I will get back as soon as possible.
Thank you for the patience.

Happy New Year!

Regards,
Jialiang Ge , remove 'online.')
Microsoft Online Community Support

=================================================
When responding to posts, please "Reply to Group" via your newsreader
so that others may learn and benefit from your issue.
=================================================
This posting is provided "AS IS" with no warranties, and confers no rights.