Forum Discussion

Tomggill's avatar
Tomggill
Copper Contributor
Sep 14, 2023

Create an external URL link so my excel workbook opens on a specific sheet.

Hi,

 

I have a Wiki site which currently uses URLS from individual excel sharepoint files for individuals on my team to open a workbook to record data.

 

I am condensing these 10 files into one big workbook with separate tabs for each individual but I still want my team to have separate links on the Wiki site which will open the excel file on the individual's assigned tab.

 

I've searched through previous suggestions on this which haven't worked for me. I'm running a 64-bit version of Excel on MS Office LTSC Professional Plus 2021.

 

Thanks.

  • LeonPavesic's avatar
    LeonPavesic
    Silver Contributor

    Hi Tomggill,

    if you want to create an external link that opens your Excel workbook directly on a specific sheet (tab), you can try this:

    1. Save Your Excel Workbook:
    - ensure that your Excel workbook is saved in a location which is accessible to your team (for example SharePoint or Onedrive)

    2. Share the Workbook:
    - Share the workbook with your team members so they have the rights to view it

    3. Determine the name of the Excel sheet:
    - find out (define) the exact name of the sheet you want to open. You can see this name at the bottom of your Excel workbook (it is better not to use special characters)

    4. Create the External URL:
    - create an external URL using the following structure:

    https://example.com/path-to-your-workbook.xlsx#sheetname

    * Replace `https://example.com/path-to-your-workbook.xlsx` with the actual URL to your workbook, and replace `sheetname` with the name of the sheet you wish to open.

    For example:

    https://example.com/your-sharepoint-folder/your-workbook.xlsx#Sheet1

    5. Share the URL:
    - share this generated URL with your team, perhaps by adding it to your Wiki site. When they click on the URL, it will directly open the workbook on the specified sheet.

     

    The URL-encoded sheet name in the URL is case-sensitive, so it must match the actual sheet name precisely.

    Please click Mark as Best Response & Like if my post helped you to solve your issue.
    This will help others to find the correct solution easily. It also closes the item.


    If the post was useful in other ways, please consider giving it Like.


    Kindest regards,


    Leon Pavesic

    • Tomggill's avatar
      Tomggill
      Copper Contributor
      Thanks Leon, I tried this but it didn't work. It just opened on the same tab again.
    • CBINM's avatar
      CBINM
      Copper Contributor

      Tested mate, does not work.

      • LeonPavesic's avatar
        LeonPavesic
        Silver Contributor

        Hi Tomggill and CBINM,

        consider implementing a “Contents Page” approach:

        1. Initiate a new sheet in your Excel workbook and label it as “Contents Page” or a similar title.
        2. On this sheet, establish links or buttons for each team member that direct to their individual sheets.

        Creating Hyperlinks to Individual Sheets:

        1. On the “Contents Page” sheet, generate hyperlinks to the individual sheets using the “Insert Hyperlink” function.
        2. To do this, right-click on the desired cell, select “Hyperlink,” and then opt for “Place in This Document.”
        3. From the list, select the appropriate sheet.

        Distributing the Contents Page Link:

        1. Distribute the link to the “Contents Page” sheet amongst your team.
        2. When a team member selects a name or specific link, they will be directed straight to that person’s sheet.

        By using this method, you create a central hub (the “Contents Page” sheet) from which your team members can effortlessly navigate to their respective sheets. This alternative can be more dependable across various environments.


        Please click Mark as Best Response & Like if my post helped you to solve your issue.
        This will help others to find the correct solution easily. It also closes the item.


        If the post was useful in other ways, please consider giving it Like.



        Kindest regards,


        Leon Pavesic
        (LinkedIn)

  • DA_Larry1558's avatar
    DA_Larry1558
    Copper Contributor

    Tomggill As long as the workbook is in a shared location, did you try right-clicking on the worksheet tab and selecting Link to this Sheet? Then you can paste that copied link in a browser and it should direct you right to the desired sheet. It's not a pretty URL, but it seems to work.

    • Janean_Schmidt's avatar
      Janean_Schmidt
      Copper Contributor
      Tried it, no change. None of these suggestions work for me at this point.

Resources