Hyperlink to spreadsheet
Find bottlenecks in your Excel workbooks
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Hyperlink to spreadsheet

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    How can I hyperlink to a perticular sheet within a workbook? Thanks in advance.
    P.S. I am trying to hyperlink from my website to a spreadsheet.

    [ This Message was edited by: av8r on 2002-02-26 04:51 ]

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,751
    Post Thanks / Like
    Mentioned
    11 Post(s)
    Tagged
    1 Thread(s)

    Default

    On 2002-02-26 03:39, av8r wrote:
    How can I hyperlink to a perticular sheet within a workbook? Thanks in advance.

    =HYPERLINK(Data!A1,"Data")

    entered in some cell in a worksheet, different from Data, which is the name of the worksheet of interest you want to hyperlink.

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Or just choose Insert -Hyperlink from the menu, select your file in the top box (leave empty if it's within the same spreadsheet) and select the location within the file in the bottom box.

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    On 2002-02-26 03:39, av8r wrote:
    P.S. I am trying to hyperlink from my website to a spreadsheet.
    if you want the HTML to hyperlink to a specific sheet in Excel : go to the sheet and name cell A1 "linktohere" or something appropriate...

    then the HTML command will be

    {A HREF="filename.xls#linktohere"}description{/A}

    it follows the same basic logic as anchoring to another HTML document
    :: Pharma Z - Family drugstore ::

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com