Insert multiple hyperlinks at same time

[AmyO]

I want to create a row for each document. I have over 100 documents I want
to link to. Does anyone know how to create many hyperlinks at one time
rather than just 1 at a time? I am using Excel 2007.

 

[Gary''s Student]

Say column A contains the list of documents:

C:\Documents and Settings\User\Desktop\book1.xls

In a helper column enter:

=HYPERLINK("file:\\\" & A1,A1)

and copy down. This will produce a nice table of hyperlinks

 

[jackie treehorn]

Could you clarify that? Does that work if you have 100 different files and
you're trying to have 100 different links?

Sorry, just confused.

Thanks,

Jackie T

 

[TopherPUSA portlock]

You have to download a simple program called "File Name Converter"
Once you have that program, Drag all the files you need the file location for into the "File Name Converter" program. It will generate a list. Copy and paste the list into a column of excel.
Once you've done that, do what the previous guy said.
in a helper column, use the formula =HYPERLINK("file:\\\" & A1,A1)

I just did all of this for the first time today and it saved me about a year of linking cells. So thanks everyone.

 

[TopherPUSA portlock]

Thank you soooo much. This saved me days and weeks of ridiculous work.