What if excel cannot locate server for external data 2011

#What if excel cannot locate server for external data 2011 windows#

As I do not have instances all I can enter is the server name. In Excel Services this is set to my server name which is 'server-name'. It has an SQL Server 2008 R2 database which has been upgraded to SQL Server 2012.

#What if excel cannot locate server for external data 2011 windows#

My environment is Windows 2008 R2 Server, SharePoint 2013 with the April Service Pack1 and a separate server with OWA2013 SP1. IР’В save the Excel workbook to SharePoint 2013 and then select 'Data' then 'Refresh All Connections' and then I get the error in the picture above.Р”В®ven more puzzling is I have another Excel workbook that also has pivot tables and pivot charts in the AdventureWorksDW2012Multidimensional cube database in 'SQL Analysis Services' and this works fine. So what am I doing? I have an Excel 2013 workbook and I create an 'SQL Server' connection to the AdventureWorksDW database, add a pivot table and a pivot chart, test in in Excel and all works fine. What is worse is I have checked the ULS (SharePoint Trace Logs), the Event Viewer Logs and the OWA Logs and I cannot find a specific error that would help pin point the problem. The following connections failed to refresh: ThisWorkBookDataModel.' We were unable to refresh one or more data connections in this workbook. We cannot locate a server to load the workbook Data Model.

So while the error message is something you may have seenР’В may times, I just can't find a solution in my case.Р”Р„nd in text just in case the image isn't viewable:

I have tried solutions in many articles but to no avail. I have been trying to fix this for days now.