Hi all,

I've just been upgraded to excel 2007 and one of my processes has stopped working.

Previously I saved the webpage that I needed onto the harddrive and then went in to Excel and imported external data. I found that this was the best way to bring data in since it allowed me to turn off the automatic data recognition function.

Now, under Excel 2007, I can't access the saved webpage on the hard drive through the Get External Webpage - web. The formatting of the table prevents me from importing as text. There appears to be a hole that saved webpages fall into.

This issue is compounded by the fact that when I go to the latest source data on the website and try to import that the table i require won't come in. I get an Error message "web query returnedno data....". and on following the trail back i get a Server error message at the source data webpage.

Any clever workarounds appreciated!

Ta