Mass change Hyperlink reference

  • Thread starter Thread starter Michael Koerner
  • Start date Start date
M

Michael Koerner

for some reason, maybe a recent update all my hyperlinked items were changed from this:

...\..\WebPages\
to
.../../../Documents%20and%20Settings/owner/Application%20Data/WebPages/

Is there a simple way to change these all at once or do I have to do it one record at a time?
 
A few people have said that this has resolved the problem for them:

File|Properties|Summary Tab|Hyperlink Base
change it to C:\
(something that's always available)

I like to use the =hyperlink() worksheet function. It has never failed me this
way:

=hyperlink("file:////yourpathtothe/something.xxx","Click me")

==============
If you have to change lots and lots and lots back...

You could use the code from David McRitchie's site:

http://www.mvps.org/dmcritchie/excel/buildtoc.htm
look for:
Fix Hyperlinks (#FixHyperlinks)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

(If it's just a few, I'd do it manually.)

=====================
ps. This is a plain text newsgroup. Most of us try to not post in RTF/HTML
(and no binary attachments).
 
Back
Top