Import Data Problem

E

Eamon

Hi,



Data->Import External Data->New Web Query->Options

and selected Full HTML Formatting, Import <PRE> Blocks into Columns, Treat
Consecutive delimiters as one, Disable Date Recognition.

Now when this is imported to the spreadsheet and I click on a hyperlink it
will not open. What could be preventing this?

If I copy from the web and past into excel the hyperlinks are working but it
is changing some numbers to dates how can I prevent it from changing some
numbers to dates?

Any suggestions would be much appreciated.



Eamon
 

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

Excel 2003 - Importing External Data - formatting problem? 2
Cell not calculating after importing data 2
Unwanted formatting with imported data 1
Import data into protected worksheet 0
How to change the date format from import link? 1
Convert $ to actual numbers in an imported web query 1
scroll automatically as data is imported into a spreadsheet 1
Importing data. Problem with datatype in column 3

Top