External URL Link to a Specific Cell in an Excel File that is on SharePoint

I would like to use MS-Teams to direct team members to specific locations within Excel files that are stored on SharePoint. For security and file management purposes, SharePoint file links have very long links.

I am aware of the following syntax for doing this for a file that is on my hard drive or the server:

path/to/Workbook.xls#'Sheet Name'!a1

Question: What is the syntax for an Excel file that is stored on SharePoint?

I tried just adding #'Sheet Name'!a1 to the end of the link but that did not work (the file opened in the location in which it was saved).

An example of the SharePoint file name would be:

https://contosa.sharepoint.com/:x:/r/sites/a_site/folder/Workbook.xls?d=wec9999fbeab94019bc8df5f986854b17&csf=1&e=BltA7

The following did NOT work:

https://contosa.sharepoint.com/:x:/r/sites/a_site/folder/Workbook.xls?d=wec9999fbeab94019bc8df5f986854b17&csf=1&e=BltA7#'Sheet Name'!a1

Thank you for assistance,

-bs

 

Question Info

Last updated July 17, 2019 Views 47 Applies to: Have the experts at Excelchat fix your formulas for free. See how.
Answer
Answer

Hi Mority,

 

Thanks for your query in this community.

 

Based on your description, we’re sorry to say it’s not possible to get an external URL for a specific cell in an Excel file. We understand the importance of this feature to you and we suggest you post a new idea in Excel UserVoice as related team can take into consideration about it. Many of the new features are implemented from the ideas provided by users.

 

Appreciate your patience and understanding.

 

Thanks,
Chitrahaas

-------------------------------------------------
If you feel a reply works for you, please kindly vote or mark it as it will be beneficial to other community members reading this thread.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.