Excel Download feature has quit working

G

Guest

Attempting to download using a web query has stopped working. This feature
has worked perfectly for years. Suddenly, when I attempt to pull down web
data from any site, such as http://investor.msn.com/external/excel/quotes.asp
I receive the following error message: "The internet site reports that a
connection was established but the data is not available." I attempted to
rebuild a simple query using the web query builder. I can see the data on the
web page, but Excel is refusing to load it. Any suggestions?
 
G

Guest

The problem turns out to be a browser security setting:
"Do not save encrypted pages to disk" If this checkbox is checked, then the
query will fail to populate the spreadsheet. Unchecking this checkbox will
allow the query to work as expected.

Not sure how this setting was changed, but it could have been with the
Cummulative IE browser update MS04-040 (889293) Dec 3rd. After applying this
update, things broke.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top