+ Reply to Thread
Results 1 to 6 of 6

Excel 2007 : Hyperlinks:on my hard drive

  1. #1
    Registered User
    Join Date
    05-09-2010
    Location
    Leeds, England
    MS-Off Ver
    Excel 2007
    Posts
    3

    Hyperlinks:on my hard drive

    I have a number of Worksheets with hyperlinks pointing to files on my hard drive. If I attempt to copy these hyperlinks from one worksheet to another, the addresses become corrupted. This problem does not occur with URL addresses. Can anyone help please...

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    re: Hyperlinks:on my hard drive

    Hello Phil Scanlan,

    can you provide a sample of the hyperlink before and after the copy operation? In what way does the corruption manifest?

    cheers

  3. #3
    Registered User
    Join Date
    05-09-2010
    Location
    Leeds, England
    MS-Off Ver
    Excel 2007
    Posts
    3

    re: Hyperlinks:on my hard drive

    Hi teylyn
    The original hyperlink address is C:\Users\Phil\Documents\Patternform\2010 Mar\herp011g.htm. If I copy this hyperlink to a new spreadsheet an error occurs when trying to use the hyperlink "The address of this site is not valid - check the address and try again". When I edit the hyperlink the address reads 2010%20Mar\herp011g.htm

  4. #4
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    re: Hyperlinks:on my hard drive

    Phil,

    the workbook that you copy the hyperlink to, has that been saved yet? I get the same kind of error message, but only when I copy the hyperlink cell into an unsaved workbook. That is because Excel can not resolve the relative path to the hyperlink target from an unsaved workbook.

  5. #5
    Registered User
    Join Date
    05-09-2010
    Location
    Leeds, England
    MS-Off Ver
    Excel 2007
    Posts
    3

    re: Hyperlinks:on my hard drive

    Hi Teylyn
    I think you have solved my problem - if I save the new workbook the hyperlink works correctly although curiously if I edit the hyperlink the address is still 2010%20Mar\herp011g.htm as per my previous example. Many thanks for your help

  6. #6
    Registered User
    Join Date
    01-05-2006
    Posts
    4

    re: Hyperlinks:on my hard drive

    i get this same message but mine is just the reverse - i add the hyperlink and it works - i save the worksheet and then i get the error and can no longer access the hyperlink?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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