Symptoms
When Microsoft Office Excel 2007 tries to connect to an OLAP cube on a server that is running Microsoft SQL Server 2005, the connection fails.
Resolution
This problem occurs because SQL Server 2008 installs the Msolap100.dll, and this file checks for the SQL Server 2008 only value DBPROP_MSMD_SUBQUERIES. When the value is not present, the Msolap100.dll fails and prevents Excel 2007 from connecting to the server.