With that done, I tested the spreadsheets once more and finally, no more errors refreshing data. (System DSNs are only modifiable by the administrator.) Now that all the errors removing and adding DSNs had gone away, I removed the User DSN for Excel Files and re added it as System DNS for Excel Files using the version 14 driver. This package has no conflicts with Click-to-run. To be exact the Microsoft Access Database Engine 2010 Redistributable which installs version 14 of the ODBC drivers for Excel and Access. (I stole their image because I forgot to screenshot my error before fixing it.) I could try installing an older driver for Office 2010. Googing the error I found this helpful page which gave me a hint of what I could try next. Playing around with the ODBC administration CPL some more, I eventually got it to generate another error when I tried to add the currently installed ver 16 Office ODBC Excel driver. It warned me that it was it did not play nicely with the Click-to-Run Office installs I had. However after downloading the x86 version of the run time (you need to match your office install architecture). (Access and Excel ODB C drivers are apparently related). Looking for a current version driver proved difficult but eventually I discovered installing the Microsoft Access 2016 Runtime should do it.
