Create an external URL link so my excel workbook opens on a specific sheet.

Tomggill As long as the workbook is in a shared location, did you try right-clicking on the worksheet tab and selecting Link to this Sheet? Then you can paste that copied link in a browser and it should direct you right to the desired sheet. It's not a pretty URL, but it seems to work.

Hi Tomggill,

if you want to create an external link that opens your Excel workbook directly on a specific sheet (tab), you can try this:

1. Save Your Excel Workbook:
- ensure that your Excel workbook is saved in a location which is accessible to your team (for example SharePoint or Onedrive)

2. Share the Workbook:
- Share the workbook with your team members so they have the rights to view it

3. Determine the name of the Excel sheet:
- find out (define) the exact name of the sheet you want to open. You can see this name at the bottom of your Excel workbook (it is better not to use special characters)

4. Create the External URL:
- create an external URL using the following structure:

https://example.com/path-to-your-workbook.xlsx#sheetname

* Replace `https://example.com/path-to-your-workbook.xlsx` with the actual URL to your workbook, and replace `sheetname` with the name of the sheet you wish to open.

For example:

https://example.com/your-sharepoint-folder/your-workbook.xlsx#Sheet1

5. Share the URL:
- share this generated URL with your team, perhaps by adding it to your Wiki site. When they click on the URL, it will directly open the workbook on the specified sheet.

The URL-encoded sheet name in the URL is case-sensitive, so it must match the actual sheet name precisely.