How to link excel to row in another workbook in Sharepoint

Betsy R 1 Reputation point
2021-10-22T16:23:34.62+00:00

I need to create a link in a cell in a local workbook to a row or specific cell in a workbook stored in Sharepoint. This row in Sharepoint could change due to added or removed rows in the workbook. I cannot use HYPERLINK since the url is much longer than 255 characters. I tried naming the cell in Sharepoint (as "svrname", copying the url, and then putting the whole thing in the following format (which would work with a much shorter url, but doesn't with this one):

https://reallylonglink#’Worksheet Name’!svrname

It opens the workbook, but not to the row/named cell I want.

Any ideas as to what I'm doing wrong? I'm not a Sharepoint admin, so if there is something that needs to be changed, I am unable to do so. Thank you!

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,649 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Hua-MSFT 27,546 Reputation points
    2021-10-25T08:20:06.107+00:00

    @Betsy R

    Welcome to Q&A forum ~
    As the tag "office-excel-itpro" focus more on genral issues of Excel client, I would reply you more from the perspective of Excel client.
    Thanks for your understanding.

    Create a link in one cell to a row or specific cells in other workbooks, this request could be achieved on local files, or files on local shared drive.
    That you could create a Name for a row or specific cells, and then go to thet workbook that you want to open links, when insterting a link, you could click Bookmark button to select this Name. The Name would be added in the form of "#<Name>" at the end of the link.
    143375-capture56.jpg
    143374-capture55.jpg
    143401-capture54.jpg

    But this way is not applicable to the files on cloud, as "Name" function is unable to be used on Excel Online. Excel could not recognize these defined Names as bookmarks.

    Besides, based on my knowledge, currently we are unable to use anchor point (#’Worksheet Name’!svrname) to link to a epecific cell or row of one workbook on SharePoint online. As you said, we could only open one specific file via it.
    Since your issue involves SharePoint, you could also post a new thread on Q&A forum with tag "office-sharepoint-online" to have a confirm.

    Any issues you could let me know.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments