I have roughly 20 external data queries located in one worksheet of an Excel
file that contains about 10 worksheets. Each web query points to a Yahoo!
Finance URL that grabs stock quotes, performance data, etc. I've
double-checked that the appropriate check-boxes are selected next the desired
'box' of data that I want to import from the Yahoo! website. I set up a
series of macros that basically highlight a cell where the data gets imported
and then the DataRefresh Data option is selected, then a new cell is
highlighted and the DataRefresh Data option is selected once again. This
seems to work fine on some occasions; however, very often the data does not
get refreshed and instead the existing data is replaced with blank cells (the
formatting also gets wiped out when blank cells are inserted where the data
used to be).

Can someone please tell me what's going on? I am frustrated beyond belief
as this seems like it should be fairly straight forward!!!

Mr. Dan