Excel automatically updating hyperlinks in Excel

Joined
Apr 20, 2006
Messages
2
Reaction score
0
hi.

I have a database in excel that has hyperlinks to each document. The problem i have is that i need to move the documents to a new folder, therefore rendering the hyperlinks useless. I have over 1000 hyperlinks that needs to be updated.

what i need to do is the change the current hyperlink to insert the name of the new folder that these documents are to be placed in.
i.e.

c:\01 management........
needs to become
c:\Registered folders\01 Management........

Is there a way of adding the name Registered folders to the path of the hyperlinks for every document automatically, as doing this manually will be too time consuming.

any help is greatly appreciated.

thanks

Leighton.
 
Joined
Apr 20, 2006
Messages
2
Reaction score
0
ive taken a look through the above site and can't find anything that answers my question.

thanks for the info though.

leighton.
 

Rush

Cool Cruncher
Joined
Nov 3, 2005
Messages
4,129
Reaction score
9
Might this help

If it's in Excel, you could just place this formula in another column (EG below assumes your hyperlinks in col A), copy down your 1000 cells and paste the results over the original as values.

="c:\Registered folders\"&RIGHT(A2,LEN(A2)-3)
 

daveydoom

Trusted Advisor
Joined
Oct 8, 2005
Messages
115
Reaction score
0
ljones60 said:
hi.
c:\01 management........
needs to become
c:\Registered folders\01 Management........
Leighton.
Use the Find and Replace feature in Excel. Edit > Replace (I think - I don't have Excel here at home). Look for 01 Management Replace with Registered folders\01 Management. Once you try it on one cell and are confident that the final syntax is correct so that it points to the right path, just click on Replace all.

Should work ;) I've never tried editing a Hyperlink this way in Excel but I can't see why it wouldn't work.

EDIT: Rush's suggestion above is another excellent way :thumb:
 
Last edited:

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

Top