topic Inserting Excel Sheet containing hyperlink in AutoCAD Forum

Inserting Excel Sheet containing hyperlink

Anonymous — Thu, 04 Nov 2021 02:21:17 GMT

Hi!I am having issues inserting an excel sheet that has hyperlinks in it to AutoCAD. When I transfer the table across to AutoCAD from excel, the data is transferred, however the hyperlink that was generated in excel only appears as a number and the link is lost. Is there a way I could transfer data from excel without losing the hyperlink?

Re: Inserting Excel Sheet containing hyperlink

jrreid — Thu, 04 Nov 2021 11:16:41 GMT

I believe it is you Excel Hyperlinks showing in AutoCAD.

You can turn them off inside Excel then Import to AutoCAD.

Hope this helps.

JRR.

Re: Inserting Excel Sheet containing hyperlink

Valentin_CAD — Thu, 04 Nov 2021 12:13:27 GMT

@Anonymous ,

@Anonymous wrote:
... Is there a way I could transfer data from excel without losing the hyperlink?

When linking an Excel file containing Hyperlinks, it will only show up as text.

To use the hyperlinks, you must open the file.

Consider "Data Link" and Insert Table 'from a data link', or use "Hyperlink".

Re: Inserting Excel Sheet containing hyperlink

jrreid — Thu, 04 Nov 2021 12:33:42 GMT

Here is a link to how you can do that.

How do I remove hyperlinks from Excel in AutoCAD? (birchlerarroyo.com)

Hope this helps.

JRR.

Re: Inserting Excel Sheet containing hyperlink

cadffm — Thu, 04 Nov 2021 12:48:27 GMT

JRR

i tried it via PM, now again in public.

Your first post missed the topic, because he like to have hyperlinks from Excel in AutoCAD,

your second post missed the topic with a totally other case (DXE links), what has also

nothing to to with the topic.

>>". When I transfer the table across to AutoCAD from excel, the data is transferred, however the hyperlink that was generated in excel"

>>"only appears as a number and the link is lost."

>>"Is there a way I could transfer data from excel without losing the hyperlink?

Re: Inserting Excel Sheet containing hyperlink

jrreid — Thu, 04 Nov 2021 13:10:33 GMT

Yes.... I did not test his method and it was all wrong.

But if you make your Data Link / Table like this guy shows the Link Stays but none of unwanted symbols show up.

Creating and Using a Data Link to Excel in AutoCAD - YouTube

Hope this helps!

JRR.

Re: Inserting Excel Sheet containing hyperlink

Anonymous — Thu, 04 Nov 2021 14:46:57 GMT

Thanks JRR. But as CADffm mentioned, my problem is that the hyperlink in excel is no copied across just as a number with no link in AutoCAD. I have 100’s of rows with image hyperlinks in excel. When transferring **** as a table/ data link to excel, I want those hyperlinks to remain.So that even when I click the number in AutoCAD, it opens the image.Is there a way to address this issue?##- Please type your reply above this line

Re: Inserting Excel Sheet containing hyperlink

AD_cbarszc0 — Thu, 30 Mar 2023 01:13:35 GMT

When you edit a hyperlink in Excel there are two fields in the format window. The upper field contains the display text, the lower field contains the link text:

AutoCAD generally ignores background property information in Excel cells (e.g. text style, cell position, etc.) during the import process. However, the hyperlinks will transfer as hyperlinks if the "Text to Display" field contains the same info as the "Address" field.

If you print using one of the AutoCAD PDF converters, the hyperlinks will also transfer into the PDF and can be accessed from Adobe when reading the output file.