question

BetsyR-0349 avatar image
0 Votes"
BetsyR-0349 asked emilyhua-msft answered

How to link excel to row in another workbook in Sharepoint

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!

office-excel-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

emilyhua-msft avatar image
0 Votes"
emilyhua-msft answered

@BetsyR-0349

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.



capture56.jpg (67.7 KiB)
capture55.jpg (49.4 KiB)
capture54.jpg (58.2 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.