question

DonQuijote avatar image
0 Votes"
DonQuijote asked DonQuijote commented

Excel Web Query and IE 11 retirement

The retirement of IE 11 has been announced for August 2021.
Working with Excel we rely on Web Queries, that we understand use their own version of IE (reference).

89058-fromweb1.jpg

To be clear this refers to Excel desktop professional 2019 on the menu: Data > Get External Data > From Web.
This doesn't refer to the Power Query version: Data > Get & Transform > From Web.

We expect that our web queries will continue to work on excel desktop after August 2019 but I would like to know if this has been confirmed (hopefully from someone on the excel team).
I would also like to know if there will be any changes such as a transition to Edge on the web queries or if they will continue to run based on their own version of IE.
Also if any updates will be required on Excel desktop for the web queries to continue running smoothly.



office-excel-itpro
fromweb1.jpg (16.9 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

emilyhua-msft avatar image
0 Votes"
emilyhua-msft answered DonQuijote commented

@DonQuijote

I can understand your concerns, but currently I do not find any KB from Microsoft related to the browser used by Web Query for Excel.
Besides, there is no related updates or features listed on Microsoft 365 roadmap.
I will update my reply here if there is any update.

If conditions permit, I suggest you open a paid support ticket with Microsoft Support to have a confirm.

Thanks for your understanding.


If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@emilyhua-msft , if this is not mentioned in the list of updates, does it mean the Web Query will continue to work as the currently work? Is there a possibility that the Web Query could be discontinued? Any additional information would be very much appreciated and I will also try to create a support ticket on my end. Thanks

0 Votes 0 ·

@DonQuijote
Thanks for your reply.
There is also a web quey on menu: New Query > From Web.
Could you please check whether this feature could be helpful?

0 Votes 0 ·

Thank you for your reply @emilyhua-msft
This could be an option for new queries but the problem are the existing Web Queries which are many.
Will the legacy Web Query stop working with the IE retirement? This would have dramatic implications.
Beyond the issue of the existing queries, the Power Query "From Web" also behaves differently so we would need to keep the option of using the legacy Web Query going forward.

0 Votes 0 ·
Show more comments