Hi Bev,

This is from Excel 2007

Title: Set the base address for the hyperlinks in a workbook

By default, unspecified paths to hyperlink (hyperlink: Colored and
underlined text or a graphic that you click to go to a file, a location in a
file, a Web page on the World Wide Web, or a Web page on an intranet.
Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.)
destination files are relative to the location of the active workbook.

Use this procedure when you want to set a different default path.

Each time that you create a hyperlink to a file in that location, you only
have to specify the file name, not the path, in the Insert Hyperlink dialog
box.

Click the Microsoft Office Button , click Prepare, and then click
Properties.

In the Document Information Panel, click Document Properties, and then click
Advanced Properties.
Click the Summary tab.
In the Hyperlink base box, type the path that you want to use.
Note You can override the hyperlink base address by using the full, or
absolute, address for the hyperlink in the Insert Hyperlink dialog box.

Thanks,
Peggy

"bevchapman" wrote in message
...
All my hyperlinks have changed their path - switched the drive and point
to a
directory that doesn't even exist. Not sure how this could happen as I
cannot find a way to change them all back without doing it individually.
I
have Approx. 3500 links!

Any ideas on how to correct these links all at once would be greatly
appreciated.