Mass renaming of hyperlinks

  • Thread starter Thread starter SM
  • Start date Start date
S

SM

I have Excel 2000 and I have a problem here. I have a
huge spreadsheet that has hyperlinks to files on my G:\
drive (ex. hyperlink to g:\myfiles\here.doc). I have
moved all of those files over to my H:\ drive. Is there a
quick and easy way of renaming/replacing all the hyperlink
references from G:\*.* to H:\*.*? Instead of editing each
hyperlink to reflect the change?

Thank you ever so much...whoever can help me and save me a
lot of work.

SM
 
That sounds like it would work, but when I go to EDIT, my
LINKS.. item is grayed out. Any more ideas?

Thank you.
SM
 
Back
Top