#1   Report Post  
Eamon
 
Posts: n/a
Default Import Data Problem

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


  #2   Report Post  
Eamon
 
Posts: n/a
Default

Any suggestions would be much appreciated.

Eamon

"Eamon" wrote in message
...
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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Import Data into same cell ib_redbeard Excel Discussion (Misc queries) 3 March 1st 05 01:08 PM
Import Data: on insert, shift data down and not right Raminhos Excel Discussion (Misc queries) 1 February 17th 05 03:08 PM
Automatic Data Import TxRaistlin Excel Discussion (Misc queries) 2 February 4th 05 11:43 PM
External data Macro Problem Excel 97 Craig Kelly Excel Discussion (Misc queries) 1 January 17th 05 04:17 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 06:55 PM


All times are GMT +1. The time now is 04:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"