+ Reply to Thread
Results 1 to 4 of 4

HYPERLINK Formula - Link to Workbook via Cell Contents

  1. #1
    Registered User
    Join Date
    11-15-2012
    Location
    Anchorage, AK
    MS-Off Ver
    Excel 2013
    Posts
    22

    HYPERLINK Formula - Link to Workbook via Cell Contents

    I am looking for a method to create a HYPERLINK formula that will open a specific workbook when the cell is clicked. The issue I am running into is that I want to be able to link the workbook's name to a specific cell in the original workbook. This is because I have multiple workbooks that need to be hyperlinked to. Below is an example:

    Workbook Name = 12345.xlsx

    HYPERLINK Function: =HYPERLINK("[C:\Desktop\12345.xlsx]","12345")

    Now, onto the problem:

    Cell A1 = 12345
    Cell A2 = HYPERLINK("[C:\Desktop\A1.xlsx]",A1) - results in an error

    Is it even possible to have a cell link in an address?

    Thank you.
    Last edited by acmichae; 03-30-2017 at 12:52 PM.

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,889

    Re: HYPERLINK Formula - Link to Workbook via Cell Contents

    A2 should be....
    = HYPERLINK("[C:\Desktop\" & A1 & ".xlsx]", A1)

    You need to concatenate string with cell value. If everything is within quotes, it will be treated as string and "A1" will be literal string.

  3. #3
    Registered User
    Join Date
    11-15-2012
    Location
    Anchorage, AK
    MS-Off Ver
    Excel 2013
    Posts
    22

    Re: HYPERLINK Formula - Link to Workbook via Cell Contents

    Thank you very much!

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: HYPERLINK Formula - Link to Workbook via Cell Contents

    Pattern: HYPERLINK(link_location, [friendly_name])

    =HYPERLINK("D:\FINANCE\1stqtr.xlsx", H10)
    or with UNC
    =HYPERLINK("\\FINANCE\Statements\1stqtr.xlsx", D5)
    or
    =HYPERLINK("[Budget.xlsx]E56", E56)
    or
    =HYPERLINK("[C:\My Documents\Mybook.xlsx]Totals")
    or
    HYPERLINK function

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 09-25-2014, 12:28 PM
  2. [SOLVED] Hyperlink within workbook without changing the name of link
    By excellearner1990 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 05-27-2014, 09:38 PM
  3. Need help creating macro that uses cell contents to link to a separate workbook
    By garysallred in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-18-2012, 03:50 PM
  4. Link contents of a Userform to Workbook feasible?
    By berlini in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-25-2011, 06:36 AM
  5. Macro to link hyperlink in a cell to another cell in a workbook
    By amangupts in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-02-2011, 12:38 PM
  6. Link A Cell In O ne Workbook To A Formula In Another Workbook
    By Minitman in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-04-2005, 02:15 AM
  7. How to link a document to a workbook with a hyperlink in excel
    By Jyoung4992 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-07-2005, 09:06 AM

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