HI, i am retrieving data from a web site to a worksheet using web query and automatically refreshing this every minute.
however now and again i get a message saying that the ''webpage didnt respond within the allocated time ...,,
the probelm is this is stopping the spreadsheet working until i click the ok button. I need this to be automatic
Can i turn this error reporting off or can i increase the 'alloted time' or would a macro be my answer.
Thanks for any help!
steve
however now and again i get a message saying that the ''webpage didnt respond within the allocated time ...,,
the probelm is this is stopping the spreadsheet working until i click the ok button. I need this to be automatic
Can i turn this error reporting off or can i increase the 'alloted time' or would a macro be my answer.
Thanks for any help!
steve