ExcelBanter - What do i enter in the server textbox to access olap?

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

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

- - What do i enter in the server textbox to access olap? (https://www.excelbanter.com/excel-discussion-misc-queries/26608-what-do-i-enter-server-textbox-access-olap.html)

blogsprite

What do i enter in the server textbox to access olap?

AI am using pivoting in excel and i am trying to access OLAP as an external
data source. I tried entering the server name in the server textbox for the
Analysis Server option, but it's giving me an "Unable to Open Connection.
Unspecified error" message.

Please help. Thanks!

All times are GMT +1. The time now is 09:01 PM.