Import External Data/New WEB Query

C

Carl Hopkins

I have a spreadsheet that does a Data/Import External Data/Web Query to get
data from a table on a web page. It has worked for years. On January 31,
a change was made to the web page and my query stopped working with the
following message: "Unable to open http://finance.yahoo.com/p?v&k=pf_1. ;
The
internet site reports that a connection was established but the data is not
available." (The actual url varies. This happens with multiple pages while
wotking with other pages from the same provider.) I have redone the query
with the same results. I tried MSN and also got the same results.
Yahoo'sresponse was they they don't know what the problem is but it isn't
anything at their end so they can't/won't do anything. I really rely on this
feature and it's absence is hurting. Anyone got any ideas? I have also
discovered through posts like this, that I am not the only one getting this
error on various pages. Since i know the web page changeed, does anyone know
what one does to a web page that produces this result? Carl
(Running current XP and Office 2003)
 

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

Similar Threads

Grouping Names in Mail Merge 0
Create a chart from a table in word thats dynamic 0
How to paste this down? 3
Pages are changing pasted image... 0
Web Query 0
How to create a Web query in Excel? 0
Adding data to MS Access from csv file 0
Import External Data 3

Top