This issue occurs if the workbook that contains some queries was created in Excel 2016. To fix this issue, install the December 8, 2015, update for Excel 2013 (KB3114354) or the December 8, 2015, update for Office 2013 (KB3085570). To work around this issue, you can save the workbook first before refresh the workbook in Excel 2013.
"We couldn't refresh the connection" error when you refresh queries in a workbook in Excel 2013
Applies To
Office 2013 SP1 Excel 2013
Need more help?
Want more options?
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.
