Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    BECCLES, Suffolk, England
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts

    XL Hyperlink (WXpHe Off2003)

    A copied value returned from an Access database to a cell in the spreadsheet looks thus: pconedclientsM-Porcs In the Db it is a valid and working hyperlink - in XL it isn't! When I edit this hyperlink in XL it reads: ../../../../d/clients/M-P/orcs. When I edit the hyperlink to be the same as the text displayed , it works. Is there a workaround for this - so that I don't have to always edit the hyperlink please?
    <IMG SRC=http://www.wopr.com/w3tuserpics/StephenElms_sig.jpg> Didn't think that I made my first post here on 5th February 2001...!

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

    Re: XL Hyperlink (WXpHe Off2003)

    What happens if you set the Hyperlink Base property to (for example) pconed in File | Properties, and then create the hyperlink?

Posting Permissions

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