Results 1 to 2 of 2
  1. #1
    Junior Member
    Join Date
    Sep 2008
    Posts
    1

    Default Excel Sort Hyperlink Issue with newer version of Excel

    Hello,

    I am working on an excel spreadsheet and am wanting to create hyperlinks based on the text, not on cell reference because I need to sort. I have a formula that works but the problem is with earlier versions of excel it does not work since it referenced .xlsx. I will need to have this formula conversion happy.

    The formula is:
    =HYPERLINK("[Book1.xlsx]Sheet2!" & ADDRESS(MATCH("A",Sheet2!A1:A100,FALSE),1),"Link To A")

    It was taken from a previous feed to link one spreadsheet to the next based on matching.

    Any suggestions on a different formula I may be able to use.

    Thanks!

  2. #2
    Senior Member
    Join Date
    Feb 2007
    Posts
    300

    Default Re: Excel Sort Hyperlink Issue with newer version of Excel

    Sounds simple to me so must be a bugga to do.
    So it does not work on 2007 xlsx files?
    There are no differences in the formula that I can see.
    Your formula looks fine from here, hope the data matches, this could be causing the issue (of...?).
    Have you got the SAME options/settings in effect for 2007 as you had for 2003?
    If you save as xls in 2007 will it work?
    Some people are alive simply because it is illegal to shoot them, most of them are in parliament.

Similar Threads

  1. Hyperlink values in Excel
    By MChanguion in forum PC World Chat
    Replies: 3
    Last Post: 22-05-2007, 11:32 AM
  2. Excel Hyperlink problem
    By brian-zl1thf in forum PressF1
    Replies: 3
    Last Post: 09-03-2005, 07:13 PM
  3. Excel Auto sort
    By Peter H in forum PressF1
    Replies: 6
    Last Post: 25-01-2004, 04:18 PM
  4. excel hyperlink
    By eve rybody in forum PressF1
    Replies: 7
    Last Post: 10-12-2003, 01:04 PM
  5. Excel Auto sort
    By Peter H in forum PressF1
    Replies: 6
    Last Post: 24-09-2003, 07:27 PM

Posting Permissions

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