I have been getting the same exact error since updating to 10.5 I can open the workbooks in 10.4.
These are workbooks that I originally created in 10.1 and I have had no problems refreshing the extracts until 10.5 so it seems to be a bug. I will see if I can narrow things down a bit.
Getting the same error with some data sources since upgrading to 10.5. Error applies to live connections too. Error does not occur when opening same workbooks in 10.4. Short term solution is to revert back to 10.4. Interesting to note that the workbook works fine on 10.5 server, so the issue seems to be isolated to desktop.