clickjohndahl
New Member
- Joined
- Oct 23, 2020
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Requirement:
- Text in Column A in Excel File E1 should hyperlink to another Excel File E2, Sheet2.
- The hyperlink should work in both Excel Online (SharePoint) and Excel Desktop.
- The hyperlink should open the pointed file in the same medium (browser or Desktop) from which it is initiated.
- 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.
- 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
- 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.