When I generate a share URL in Excel Online, it takes the following form:

https://onedrive.live.com/view.aspx?
  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&

remeika

Posted 2014-08-28T09:42:25.723

Reputation: 161

You could try and add #Sheet3 to the ithint parameter... something similar to this line: ithint=file%2cxlsx#'Sheet3'& ... source

– mk117 – 2014-08-28T10:18:52.233

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.

Sergey Rodin

Posted 2014-08-28T09:42:25.723

Reputation: 11

Note: this appears to also require that you set &action=embedview, at least I couldn't get it to work without that action parameter. – richardtallent – 2018-05-11T18:04:36.387

Followup: &action=default works if the default is to use Office Online. Also, the sheet name must be wrapped in single quotes if it contains non-word characters. – richardtallent – 2018-10-18T17:08:13.927

Can I modify Excel Online share URLs to open to a specific worksheet?

Edit

Answers