I have inherited an issue trying to get Excel Workbooks to load data from an ASPx page to a backend SQL Database.
It works fine in Explorer, but not at all in Edge or Chrome.
It works fine in Explorer, because explorer authenticates the user before doing the QueryTables.Add . There is nothing in the code to prompt it to do it, but the windows security window pops up fine in explorer and asks the user to login but does...