Editing Intra-Network Hyperlinks in a Spreadsheet

[Winston]

We have an Excel spreadsheet with several hundred
hyperlinks to various files on one pc in our network. When
we access this spreadsheet in its normal location, the
hyperlinks work beautifully.

However, on the rare occasion that that pc is down, even
though we have a (daily) backup of all these files that we
can save on some other pc, the hyperlinks all refer to the
original pc. Is there some way, like a Find/Replace
function, that we could edit all the hundreds of
hyperlinks at once to show the new pc's location instead
of the old one?

Thanks!