Although Excel is a great tool to analyze data, it does not support a native driver to access Analysis Servives 2005. In order to take full advantage of the analysis services you need to install a special addin.

If you want to have even more control about the data you’re accessing, you might want to connect to analysis services using ADO. The apropriate driver is supplied with the SQL Server 2005 Feature Pack.