script error pop up while trying to download data for web

continuous script error message pop ups,  while trying to get external data in excel 2016. how do I get rid of these pop ups permanently.

 

Question Info


Last updated October 13, 2019 Views 14,613 Applies to:
Hi Amin,

Please try disabling script warning with steps below:
a. Press Windows key + R and type inetcpl.cpl and press OK.
b. On the Internet Options windows, click on Advanced.
c. Check "Disable script debugging (Internet Explorer)" and "Disable script debugging (Other)" and uncheck "Display a notification about every script error."
d. Click on OK.  Now, check for the issue.

If the issue persists, please confirm the following information:
1. Does the issue happen to some specific sites or all websites?
2. Delete all Temporary Internet files and website files. Open Windows key + R and type inetcpl.cpl and press OK. Then click Delete under Browsing history.
3. Try the Online Repair for your Office applications. Open Control Panel > Programs and Features, select Office application and click Change > Online Repair > Repair.
4. Make sure your Internet Explorer and Office applications are up to date. Please share with us the detailed version numbers.

Regards,
Jiaxing

17 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

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

How satisfied are you with this response?

Thanks for your feedback.

Hi Bian,

I have performed the 2 methods but I still have the problem of the script error pop ups. When i went to  "Disable script debugging (Internet Explorer)" and "Disable script debugging (Other)" and uncheck "Display a notification about every script error." they were already disabled and after completing the Online repair there hasn't been any improvement.

the version I have installed are:

IE Verision 11.0.9600.18426

Update versions: 11.0.34

Excel Version: 16.0.6741.2063

Thank you,

Amin

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

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

How satisfied are you with this response?

Thanks for your feedback.

Hi Amin,

Thanks for your update.

To move forward, please try the Advanced methods in the article below to troubleshoot the script error:
How to troubleshoot script errors in Internet Explorer

Meanwhile, I found the following article which mentioned a 3rd party tool to fix the issue:
Problem with Script Error Yahoo Finance Web Query Excel?

If the issue persists, we’d suggest you post the issue in our Excel IT Pro forum for professional help.

In addition, to import data from a web page, you can also consider the workaround by using the New Query > From Web option. Here is the link for your reference:
Get & Transform: An Alternative to Excel’s Web Browser

Disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.

Regards,
Jiaxing

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

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

How satisfied are you with this response?

Thanks for your feedback.

Jiaxing,

I was having the same problem as Amin, continual scripting error pop-ups when I tried to import data from the web.

Like Amin, when i went to  "Disable script debugging (Internet Explorer)" and "Disable script debugging (Other)" and uncheck "Display a notification about every script error." they were already disabled.

Then I followed your suggested steps:

2. Delete all Temporary Internet files and website files. Open Windows key + R and type inetcpl.cpl and press OK. Then click Delete under Browsing history.
3. Try the Online Repair for your Office applications. Open Control Panel > Programs and Features, select Office application and click Change > Online Repair > Repair.

My computer proceeded to uninstall Microsoft Office 2016 from my computer! How can I go about reinstalling it?

Bryce

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

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

How satisfied are you with this response?

Thanks for your feedback.