Data Query Problem - PLEASE HELP!
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 |
All times are GMT +1. The time now is 12:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com