|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 15th, 2005, 02:33 PM
|
|||
|
|||
Absolute vs Relative path
I have an issue with hyperlinks in Excel 2000. I am trying
to create hyperlinks to documents/XLS files on a our network, and want to use absolute paths. I can "point" the hyperlink to the document, click on the link and it works fine, with the address showing as an absolute path (\\server\folderA\folderB\doc.xls). When I save the document the link changes from the absolute path to a relative path (../../../ doc.xls). This creates a problem because when others try using the hyperlinks, they do not work (office clients range from 2000 to 2003). Help. -- 
|
|
#2
June 15th, 2005, 02:54 PM
|
|||
|
|||
|
I've never had any trouble with the =hyperlink() worksheet function. If it's
possible, you may want to use this. An untested alternative: File|Properties|Summary Tab change the hyperlink base to C:\ Can you post back with your results if you test the hyperlink base suggestion? Thanks, K2H wrote: I have an issue with hyperlinks in Excel 2000. I am trying to create hyperlinks to documents/XLS files on a our network, and want to use absolute paths. I can "point" the hyperlink to the document, click on the link and it works fine, with the address showing as an absolute path (\\server\folderA\folderB\doc.xls). When I save the document the link changes from the absolute path to a relative path (../../../ doc.xls). This creates a problem because when others try using the hyperlinks, they do not work (office clients range from 2000 to 2003). Help. -- -- Dave Peterson
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to creat relative and shorthand file path names? | 2dogs | General Discussion | 1 | May 15th, 2005 12:11 PM |
| How to create relative and shorthand file path names | 2dogs | General Discussion | 4 | May 14th, 2005 08:49 PM |
| hyperlink changes address from absolute path to relative | tnybecker | General Discussion | 2 | January 7th, 2005 08:35 AM |
| Setting a Relative path | Powerpoint | 1 | August 22nd, 2004 06:01 AM | |
| Relative Path Links in a Master Document? | Rob_Bond | General Discussion | 1 | August 2nd, 2004 02:42 PM |
Linear Mode
