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!