Problem with web query, cannot locate server error

Hi all

I have a web query running which I usually refresh every 1 minute, and it works really well, except for every now and again the error message 'cannot locate proxy server' appears and I need to click on the 'ok' button before my web query will refresh again. Obviously this is a problem if it happens over night as I am unable to get it refreshing again until I press that button. Is there a way of getting around this?

I use a macro to refresh my data and I am not sure if this is causing the problem. I am quite an amateur when it comes to vba's so if anyone has any ideas on whether this could be the source of my problem I would be really grateful.

The vba refreshes the data from cell A1 into the cells to the right.

Thanks
Gemma