I just spent a day looking into why Excel Services could not refresh an Analysis Services 2005/2008 external data source. the message was "Data Refresh Failed... The data sources may be unreachable, may not be responding, or may have denied you access" Read More...