Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Jun 2003
    Location
    Utah, USA
    Posts
    412
    Thanks
    39
    Thanked 5 Times in 5 Posts

    Links Within Spreadsheets (XP Pro SP-2)

    Can someone explain this to me, and perhaps offer a workaround?

    I built a spreadsheet (on my hard drive) in my office with links to other files on our webserver (both spreadsheets and PDF files). I then uploaded this spreadsheet to our webserver. The links were typed as complete absolute URL's in Excel's link window.

    However, when I look at this spreadsheet from other PC's on our network the links are not what I typed in. The links to the PDF files are the complete URL's that I typed in. However, the links to the spreadsheets were changed by Excel to URL's that are relative to the PC that I wrote the spreadsheet on. Of course, those URL's won't work from a different machine.

    This behavior was duplicated by one of our IT people, who could offer no further help.

    An answer other than "Blame Microsoft!" is desirable.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Links Within Spreadsheets (XP Pro SP-2)

    When you create the hyperlink, in the "insert hyperlink", uncheck "use relative path for hyperlink"

    Steve

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Links Within Spreadsheets (XP Pro SP-2)

    Excel 2002 doesn't have a "use relative path for hyperlink" check box, unfortunately.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Links Within Spreadsheets (XP Pro SP-2)

    With the workbook open, select File | Properties. In the Summary tab, there is a Hyperlink Basis property at the bottom. If you leave it blank, all hyperlinks will be stored relative to the path of the workbook. If you enter a path, all hyperlinks will be stored relative to this path. So if you enter the common part of the location of the files you link to, you should be OK.

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Links Within Spreadsheets (XP Pro SP-2)

    Apart from the suggestions already made, you might consider using the HYPERLINK worksheet function to create the links, which enables you to enter literal strings as the paths. These will never be affected by Excel.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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