HELP: Excel changed all my hyperlinks A:

  • Thread starter Thread starter Arska
  • Start date Start date
A

Arska

Help

For some reason Excel went and changed all my hyperlinks to point to my
floppy drive a:\ -WHY?

Is there any way I can automatically remove the a:\ hyperlink
references, manually renaming is going to take ages.

Excel's replace function doesn't seem to work with hyperlinks :-(


-Arska
 
Hello Arska,

Have you tried find and replace?

Press ctrl+h
Find what: A:\
Replace with: C:\My Documents (assuming this is where the file you want to
link)
Then hit Replace All

or if your using xl 2002 you can go to EDIT|links then hit change source

Hope this could help

Jon-jon
 
Back
Top