I have a user that has a 2MB Excel workbook with hundreds of hyperlinks to
other Excel spreadsheets - which are all located on his external hard drive
(G drive). Something happened with his login settings, and ended up changing
all of the hyperlinks to C:\Documents and Settings\Administrator\xxx. Do you
know of a way to change all of the hyperlinks back to G:\ ? If so, is there
a way to hard code the hyperlink so that they do not change again?

Thank you in advance.