I just ran into a very odd situation trying to connect a user's Excel 2013 to a SQL Server Analysis Server using Data Connections. When setting up the Data Connection, it was acting as if the server wasn't there - an "unable to connect to server" or "server not found" sort of thing. Needless to say, spelling was checked, basic network connectivity was checked, and SSAS connectivity was successfully checked on another computer.
Additionally, the local firewall was turned off, a different user logged in and tried (and failed), the computer could ping the server, and even a SQL Server Data Connection in Excel to the same server worked.
I finally did a Repair on Office 2013 in Add/Remove programs (or, now, Uninstall a Program), and that did the trick. There must have been something corrupt in the components that handled the SSAS Data Connections.
Hope this helps anyone else who runs into this.
