+ Reply to Thread
Results 1 to 5 of 5

My hyperlinks are being changed when I hit save in excel.

  1. #1
    Registered User
    Join Date
    03-26-2007
    Posts
    2

    My hyperlinks are being changed when I hit save in excel.

    My hyperlinks are being changed when I hit save in excel. Eg a perfectly good hyperlink, which works well…
    \\wwleeds-srv\wwstandards\Technical_Guides\Part_L_information\CIBSE_guide_F_Energy_efficiency_in_buildings.pdf

    ...changes to an unusable string of nonsense on hitting save:
    ../../../../../wwstandards/Technical_Guides/Part_L_information/CIBSE_guide_F_Energy_efficiency_in_buildings.pdf

    I just don’t know why it changes at all when it saves, it puts all the back slashes to forward slashes, removes the server name and puts in a whole load of forward slashes.

    Clicking on the saved hyperlink brings up the error message:
    “The address of this site is not valid. Check the address and try again”

    I have tried inserting the hyperlink by right clicking on the cell, selecting hyperlink and then browsing to find the file on the server that I’m after, then testing it to see if it works, and it does until I hit save. I then tried fixing it by editing the hyperlink. This also works until I hit save.

    Please could you let me know how to solve this problem?

    I've checked the microsoft website for help and I think that this is suggesting that I do what I have already done ( http://support.microsoft.com/kb/156893 ), if so it doesn’t work, if not please can you help me with plainer instructions? ( I don't think it works).

  2. #2
    Forum Contributor
    Join Date
    02-23-2005
    Location
    England
    Posts
    110
    I may be wrong, but I think that Excel is saving your hyperlink as a relative link (relative to the location of your excel file). You could try the following (extracted from the Excel Help files):

    Set the base address for the hyperlinks in a workbook
    By default, unspecified paths to hyperlink destination files are relative to the location of the active workbook. Use this procedure when you want to set a different default path. Each time you create a hyperlink to a file in that location, you'll only have to specify the file name, not the path, in the Insert Hyperlink dialog box.

    On the File menu, click Properties.
    Click the Summary tab.
    In the Hyperlink base box, type the path you want to use.
    Note You can override the hyperlink base address by using the full, or absolute, address for the hyperlink in the Insert Hyperlink dialog box.

  3. #3
    Registered User
    Join Date
    03-26-2007
    Posts
    2

    What a champ!

    Thanks mate, that's fixed it. I'd never have worked that out, cheers.

    Jenny

  4. #4
    Forum Contributor
    Join Date
    02-23-2005
    Location
    England
    Posts
    110
    Glad to be of help. And thanks for the feedback.

  5. #5
    Registered User
    Join Date
    05-26-2008
    Posts
    2
    Hi folks,

    I hope it's okay to resurrect this thread - better to do so than to create a new thread on the same subject, no? Anyway, I'm having a similar issue to that experienced by Jennifer.

    I have several hyperlinks in a workbook, which link to a mapped network "drive". The server address is "\\server\share\location" which resolves perfectly fine, and I have set the Hyperlink Base to "G:\", which stops the links from looking like "../../location", so that's good, but I want to have the links resolve to "G:\location" instead.

    I create links to "G:\location" using the Insert Hyperlink dialog, but Excel immediately changes these to "\\server\share\location". Is there any way to stop this from happening?


    This may all be a bit confusing. Basically what's happening is that clicking on the links opens up the location I want, but the Address in the Windows Explorer window shows the location as "\\server\share\location", whereas I want it to show the location as "G:\location". I've attached a screenshot.

    Any ideas?

    THANKS IN ADVANCE.
    Attached Images Attached Images

+ 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