无法将Excel连接到Analysis Services服务器

We have an SSAS server with a cube deployed on a server over the WAN.. We are trying to connect to the cube from Excel on various client workstations. The server is not on a domain with the clients. It "works" for some of us but not for others. We are trying and failing yet to determine what the difference is on the machines that work versus the ones that don't. However, even for the ones that work, it isn't as seamless as we think it should be. I'll explain:We have an SSAS server with a cube deployed on