I am having a problem with MSEXCEL's web query on finance yahoo.?

Question

MSEXCEL's web query used to work flawlessly with downloading finance.yahoo.com's historical data page historical data table. In the last two weeks many of the query's frequently return an error. The run time error is1004. This happens most of the time with some of the querys, and ocassionally on others.
Can anyone help?

Answer 1

I created a sheet and connected to the historical prices page for a stock I like. It pulled down appears to be okay. You should go to the spreadsheet click on the cell with the query then edit the query and make sure the website pops up showing you the table that is linked. If you are using QueryTables in a macro, I do not have a solution at this time.