Excel 2003 & Windows 7 error when connecting to SSAS cube
I have a frustrating error that I have not been able to resolve through the usual channels.
I am attempting to connect to a data cube (SSAS) via excel 2003 on any machine running windows 7. The error received is :
"Excel was unable to get necessary information about this cube. The cube might have been reorganized or changed on the server.
Contact the OLAP cube administrator and, if necessary, set up a new data source to connect to the cube."
I have multiple cubes on multiple SQL servers running SSAS 2005 + SSAS 2008R2, neither work.
When I use excel 2003 with windows XP I have no issue, nor with Windows 7 and Excel 2007 or 2010.
The windows firewall has been disabled and all microsoft updates have been applied.
It is not practical to upgrade Excel on these machines just yet due the number of machines and training issues.