Excel Web Query Options

Hello,

I previously had a web query set to retrieve information from a specific URL. This URL had a log in screen that I would log into, then the query would pull the information that I needed.

Now that IE is being phased out, my query is not working as it did previously. I went to web options and it is only showing IE.

Is there a patch or a way that will allow my excel to use Edge instead of IE when completing the web query, so that I can log in?

Dear Suzette,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

Seems that you are using the legacy Web Query option to pull the data. Is this what you currently have in the workbook? If it is, I am unaware of any solution or workaround to switch to Edge from IE based on my research.

Instead, have you tried building the query with From Web option? Are you able to authenticate to the website with this option?

Image

If this doesn't help, the best solution is to build up Excel VBA to retrieve the data. I would recommend you re-post the query to Stack Overflow for programming-related queries referring to this article.

Sincerely,

Ryan | Microsoft Community Moderator

• Beware of Scammers posting fake Support Numbers here.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated April 13, 2025 Views 201 Applies to: