When I generate a share URL in Excel Online, it takes the following form:
resid=<DOCUMENT ID>& ithint=file%2cxlsx& app=Excel& authkey=<AUTH KEY>Is there a parameter I can add to this URL so that it will open up to a specific worksheet within my document?
Edit
Thanks to @mk117 for suggesting the following approach in the comments.
I can confirm that the following additions to the ithint parameter do not work (assume disired worksheet name is 'Chart'):
ithint=file%2cxlsx#'Chart'&ithint=file%2cxlsx#'!Chart'&ithint=file%2cxlsx#Chart&ithint=file%2cxlsx#!Chart&
2 Answers
It works if you set active cell in the link, and specify sheet and cell. Try adding &activeCell=%27Sheet1%27!A1 to the URL, where Sheet1 is the name of the worksheet you're linking to, and !A1 is the name of the cell on this worksheet.
This worked for both selecting the worksheet and selecting an active cell when the sheet name has no spaces. However, if the sheet name has spaces, I can get to the worksheet (with or without quotations), but it does not select the cell if the sheet name has spaces.
yourlinkhere.com
?resid=X <-- this should be your ID.
&ithint=file%2cxlsx
&authkey=X <-- this should be your auth key.
&activeCell=[SHEET]![CELL] <-- Replace [SHEET] with the name of your sheet, then put an exclamation point, and the cell, for example &activeCell=Sheet1!A10
Hope this helps!
/ Seb
