Across our network users have previously been able to run the data query as explained in the Sage article
Now all users when they try to run the query have Excel crash on them with no errors.
This is across Windows 7/10 and also Office 2013 and 2016.
We have two locations one is running Sage 2016 and the other is 2017. This issue is happening in both locations.
Has anyone else come across this and been able to resolve it? Tech support is not helpful on this particular issue.
Instead of clicking Finish, try opening the query in MS Query.
If you get results here, Sage ODBC is fine and you have a problem with your Excel.
Frank S. Did you ever resolve this issue? I am seeing this error on an upgrade from Sage 100 Standard v2016 to Standard v2020. The workbook w/MS Query updates fine on 2016, but 32-Bit Excel disappears w…
So yes, I did find a solution to this problem.
We moved those users to Windows 10 version 1803 and installed all of the Office updates for Pro Plus 2016. When this was first posted it was affecting all…
