[DataSource.Error] Web.Contents failed to get contents from " URL" (500):Internal Server Error

alfcorr

New Member
Joined
Dec 13, 2016
Messages
9
Hello guys, I am running a web dataquery on Excel 2016, which dumps the data to a table on a Sheet. This runs continuously, and have it set to refresh in backgound automatically every 5 minutes.

Every so often I get an error warning : [DataSource.Error] Web.Contents failed to get contents from " https://................................" (500):Internal Server Error
This completely blocks all excel, and forces the user to click the "OK" button,

This dataquery is part of a tool that is designed to run unattended, so this error completely trumps the purpose of the tool.
Rather than look for the causes of the error, which seem to be due to some connection error with the outside server, I have been looking for a way to supress these error warnings, and have found nothing.

Could anybody help me with a solution to this?

Thanks,

Alfredo
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Forum statistics

Threads
1,223,888
Messages
6,175,219
Members
452,619
Latest member
Shiv1198

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top