Hello,

I use the "New Web Query" feature to import data into Excel 2003 and 2007. The website requires Basic Authentication however. The first time I enter the URL of the website I wish to import data from, the Excel responds appropriately and displays the authentication dialog.

However, once I close the program and my session with the site ends, and then reopen Excel and try to refresh the data, it fails with the error "Cannot find datasource".

Actually the datasource responds correctly with the HTTP 401 code so Excel should give the opportunity to enter their credentials.

The absence of this feature basically forces the user to either create some mechanism to enter the credentials in the URL or do some macro programming as far as I know...

Does anyone have any suggestion????

Dave