Refreshing web data error

mskli

New Member
Joined
Feb 20, 2017
Messages
37
Hello I get stock/option data from the Montreal Exchange. I have the appropriate web page in each of my Workbooks.

These Excel Workbooks have worked for years until recently. I get the following error when I run the first symbol (see attached) "unable to open http://" etc. No matter what symbol I run first gets this error.

To fix this I simply refresh it a few times (2 or 3) and then the data will finally come in and the will work fine for all remaining symbols. After it comes in for "any" one symbol and is saved - then it works for all symbols as it always has.

So there is no problem with the link itself and no issue with my internet connection.

I have also had no issues if I run this on another computer. So, I'm thinking there is an issue with one my settings in Excel?

Any suggestions?
 

Attachments

  • excelerror.PNG
    excelerror.PNG
    36 KB · Views: 14

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Forum statistics

Threads
1,223,880
Messages
6,175,157
Members
452,615
Latest member
bogeys2birdies

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