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