ExcelBanter - cannot connect to SSAS 2005 from XL2007

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - cannot connect to SSAS 2005 from XL2007 (https://www.excelbanter.com/excel-discussion-misc-queries/232264-cannot-connect-ssas-2005-xl2007.html)

Jim

cannot connect to SSAS 2005 from XL2007

I can not connect to a named instance of SSAS 2005 (e.g.
servername\instancename) from XL 2007. I get "server not found". If I leave
off the instancename I get "server busy/not running". How do I connect to
the analysis server?

All times are GMT +1. The time now is 02:35 PM.