After many tries, today I came to the conclusion that Analysis Services 2005 SP2 breaks the Excel 2007 calculated member selection feature. I already talked about this issue here, but today I found the way to reproduce the error. This is a scenario that works well: Analysis Services 2005 SP1 + hotfixes (build 2153) Excel 2007 RTM Cube ...