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
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