+ Reply to Thread
Results 1 to 3 of 3

Absolute vs Relative path

  1. #1
    K2H
    Guest

    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. #2
    Dave Peterson
    Guest

    Re: Absolute vs Relative path

    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

  3. #3
    Rob Cooper
    Guest

    Re: Absolute vs Relative path

    thanks for that, have been struggling with the same problem!

    "Dave Peterson" wrote:

    > 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
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1