One of our users got a new machine. Obviously, this "event" has caused him to lose the ODBC connections used within Excel's Workbook Connections.
I tried to recreate the ODBC connections through Administrative Tools in Control Panel, based on the settings in the Excel "Workbook Connections" Properties.
Unfortunately, upon refreshing the workbook, I received the error message saying "Data source name not found and no default driver specified."
Excel, then, brought up the "Select Machine Source" window.
My ODBC connections did not appear in that window. So, I clicked its "New" button and got a message saying that the user is logged in with "non-Administrative" privileges.
I confirmed with IT, over a remote session, that the user's login is indeed an Administrator on this Windows 10 machine.
IT and I are both befuddled.
Thank you! Much appreciated!