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):
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!