import data to excel 2016 from web throwing Script error.

Question

when I try to import data to excel 2016, from web , instead of asking URL , it is automatically put a url https://www.msn.com/?ocid=iehp and , throwing script error. could not able to get the default screen or power query from that window.

Default screen suppose to be look like this instead of the above screenshot

Answer 1

Hi,

I am Shakiru, an independent advisor and a user like you, and I am glad to be helping you out today.

Have you checked if this happens on all websites or on a particular website?

Please try disabling the script warning:

1. Press Windows key + R and type inetcpl.cpl and press OK.
2. On the Internet Options windows, click on Advanced.
3. Check "Disable script debugging (Internet Explorer)" and "Disable script debugging (Other)" and uncheck "Display a notification about every script error."
4. Click on OK. Now, check for the issue.

You can also check Virfranz Man's comment on the thread below with a similar issue: https://answers.microsoft.com/thread/29305f48-4ba8-4a7a-b1e0-212d5f39f12d

Please let me know if you need any other assistance and I will be more than happy to help further.

Thank you

Best Regards, Shakiru

Answer 2

I think you did not understand my question. When I click import from web. It automatically pick a website by default and giving me the 1st screenshot before I type anything. In general it should show the second screeshot. .

Somewhere excel picking the website by itself Not sure where excel took the website https://www.msn.com/?ocid=iehp and doing its own

Answer 3

Hi,

Thank you for the feedback.

What about if you open Excel in Safe Mode, do you experience the same?

If yes, you can run Online Repair Microsoft Office, Please check here: https://support.microsoft.com/office/7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b

Thank you

Best Regards, Shakiru

Answer 4

thanks for trying to help But the solution you have provided not worked .

thanks