I have multiple Web Queries in my workbook. The majority of them work just fine, but there are two that have been giving me issues. When Excel is totally closed out, the selected tables to be imported are unselected, and thus need to be manually reconnected every time I would like to open and use the workbook.
I have noticed that these two queries come from the same website. It does not require a password to access the webpage either (at least, that is, it does not prompt you to input a username/password). Does anyone have any ideas why this might be occurring? Any help would be appreciated, thanks!