J
JustinB
is it possible to put a delay before a web query executes?
i have an excel spreadsheet that has about 8 tabs in it. when yo
change the value in a particular cell of the first tab, the other
will recognize it and update the data for the new value.
the problem is that once the queries begin to refresh, i get a
"invalid web query" error. if i press ok and then refresh the queries
it will fill in more data, and then give another error. after about
or 3 of the same errors and retrying, it will eventually populate th
page fully and give no errors.
i believe this has something to do with the queries are running a bi
faster than the web pages load. is it possible to put a delay withi
the query before it executes?
edit: by the way, this is for fundamental analysis on stocks. enter
symbol and the fields all populate automatically. i have alread
integrated an excel spreadsheet to a paysite (investools), and it work
fine. now i am trying to make one that runs off of msn money's site, an
its giving me trouble
i have an excel spreadsheet that has about 8 tabs in it. when yo
change the value in a particular cell of the first tab, the other
will recognize it and update the data for the new value.
the problem is that once the queries begin to refresh, i get a
"invalid web query" error. if i press ok and then refresh the queries
it will fill in more data, and then give another error. after about
or 3 of the same errors and retrying, it will eventually populate th
page fully and give no errors.
i believe this has something to do with the queries are running a bi
faster than the web pages load. is it possible to put a delay withi
the query before it executes?
edit: by the way, this is for fundamental analysis on stocks. enter
symbol and the fields all populate automatically. i have alread
integrated an excel spreadsheet to a paysite (investools), and it work
fine. now i am trying to make one that runs off of msn money's site, an
its giving me trouble