Please help We have two shared areas which we map to using two different drives. These are mapped using DFS. Trying to set up a hyperlink between two Excel docs; one on each mapped drive. When we iniitally set it up the hyperlink works fine, but if we save it we get an error about it not being able to find the doc. When we check the properties of the hyperlink the path has changed to \..\..\..\folder\folder If we map the drives using a non DFS path it works fine. Our whole company uses DFS so cant just map the drives non dfs Thanks

Set a hyperlink base for a document Use this procedure when you want to set the path for all the hyperlinks in a document — for example, when you are creating a document for your company's intranet, and you want to link to a series of corporate logos that are stored in a group of subfolders on the intranet. If you do not specify a hyperlink base, the paths to hyperlinks are relative to the document they are contained in. Open the document you want to set a hyperlink base for. On the File menu, click Properties, and then click the Summary tab. In the Hyperlink base box, type the path you want to use for all the hyperlinks you create in this document. Note You can override the hyperlink base by typing the full address for the hyperlink in the Insert Hyperlink dialog box instead of selecting a file from the list. This sets the path to the hyperlink as a fixed file location. thanks