Mass renaming of hyperlinks

[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

 

[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