Making Excel hyperlink to another Excel sheet work for both Excel Online (SharePoint) and Excel Desktop.

[clickjohndahl]

Requirement:

1. Text in Column A in Excel File E1 should hyperlink to another Excel File E2, Sheet2.
2. The hyperlink should work in both Excel Online (SharePoint) and Excel Desktop.
3. The hyperlink should open the pointed file in the same medium (browser or Desktop) from which it is initiated.

What works now:

1. So far, the hyperlink works in Excel Online (SharePoint) after appending &activeCell=%27E2%27!A1 in the E2 web URL, means it correctly opens E2 with Sheet2 as the active sheet.
2. When tried the same hyperlink from Excel Desktop, it does open E2 in Excel Desktop after checking the option Excel Desktop > Options > Advanced > Link Handling > Open supported hyperlinks to Office files in Office desktop apps

What doesn't work:

1. But it does not automatically make Sheet2 as the active sheet when using Excel Desktop. This is where I am struggling to make it work.

Any suggestions are greatly appreciated.

 

[daverunt]

Hi,

Unfortunately I don't have SharePoint so I am limited in my input.
However I can't see how adding that bit of code opens Sheet2. The sheet isn't mentioned, It just points to (workbook) E2 cell A1 (on whichever is the Active Sheet)

Here's an example of a hyperlink in a cell that opens a different workbook that might give you some pointers.

=HYPERLINK("C:\Users\DT\Desktop\Junk\Book1.xlsx#Sheet2!A5","Click Here")

 

[clickjohndahl]

Sorry, it should be &activeCell=%27Sheet2%27!A1 and thanks for your response.
And appending sheet name with # works for Excel Desktop only, not in Excel Online (SharePoint), which appending activeCell as mentioned above works for Excel Online (SharePoint), but not for Excel Desktop. I am trying to find a link that works for both platform.