how to get rid of script error in excel web query

Savitri K 0 Reputation points
2024-04-14T10:53:21.63+00:00

I am using ms excel 2016 standard and OS is windows 10. I have been trying to use web query feature in excel to download a data from a website but have been getting scripting error. how i can avoid that. Also i guess my excel tries to open the web page thru Internet explorer. i don't have intrernet explorer in my desktop. But i have MS edge. can I change to google chrome?

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,641 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Jiajing Hua-MFST 4,825 Reputation points Microsoft Vendor
    2024-04-15T08:39:04.1466667+00:00

    Hi @Savitri K

    Does this issue occur with other web URLs?

    The web access via EXCEL 2016 is IE based, it can not be changed.

    Please try New Query > From Web option, check whether you may load the data successfully.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    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.


    0 comments No comments

  2. Savitri K 0 Reputation points
    2024-04-17T06:35:05.67+00:00

    Hi @Jiajing Hua-MFST - Thank you for the response

    Does this issue occur with other web URLs? - yes it does.

    Please try New Query > From Web option, check whether you may load the data successfully. - The scripting error did pop up again. Though I can just escape it but that will be a manual intervention.

    0 comments No comments