Have you tried this?:

In the Workbook with the hyperlinks:
FilePropertiesSummary
€¢Hyperlink Base: Enter whatever base path you need.

All workbook hyperlinks will be saved relative to that setting.

Does that help?

€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢
Regards,
Ron


"RWS" wrote:

in a worksheet, how do i set the base address for hyperlinks? i hyperlink
hundreds of product photos to item numbers in my inventory worksheet. when
inserting hyperlinks i have to move up the directory numerous levels to get
to my vendors folder where i store the item photos. i have tried the process
microsoft recommends but it doesn't work.