I have one excel with sheets ( Sheet1 and Sheet2) uploaded in sharepoint.

Requirement : to create a URL to access the uploaded excel document and open specific sheet (say Sheet2)

Any solutions here?

  • Do you want a URL to open exact sheet in browser using Excel Web App? What is your SP version & edition? Commented Feb 23, 2016 at 10:01
  • SP 2007 and Version
    – Pravin B
    Commented Feb 23, 2016 at 10:06
  • Yes want to open exact sheet . doesn't matter if it opens the sheet in excel client.
    – Pravin B
    Commented Feb 23, 2016 at 10:08
  • I tried opening the sheet by adding hyperlink for URL (path/to/Workbook.xls#SheetName!a1) in worddocument. It opens specific sheet ; however, it does not open if i direct access the same URL from browser.
    – Pravin B
    Commented Feb 23, 2016 at 10:12

7 Answers 7



works to open the spreadsheet in a web browser, thanks to @Vincent Crenshaw but


doesn't work. Finally, this works for me: https://superuser.com/a/1115331 https://sharepoint.stackexchange.com/a/227779/99645

replacing &action=default with &activeCell=%27Sheet1%27!A2

is the key!

  • There is another key... the base URL for me could not be the one you obtain by going in Excel desktop app > File > Info > Copy Path. Instead I absolutely had to use the URL that's used when you're using the web view of the workbook (it automatically redirects to this one when you use web=1). From there, replace just how you described - that is, swap action=default for the activeCell=STUFF
    – DAG
    Commented Mar 21, 2023 at 12:51

That # symbol in URL usually divides an address and fragment location, and fragment location is never transmitted to server, but handled by client. See https://en.wikipedia.org/wiki/Fragment_identifier :

In URIs a hashmark # introduces the optional fragment near the end of the URL ... The fragment identifier functions differently than the rest of the URI: namely, its processing is exclusively client-side with no participation from the web server

So there's nothing SharePoint Server should do here, cause handling of #... part is a client app's job. And regarding those clients: You can use https://site/lib/workbook.xlsx#'Sheet1'!A1 links in some Office application. I can confirm those specific links are handled well in Excel / Word / PowerPoint, and had never seen them work in Project / Visio / Outlook.

This is how it actually works: fragment-aware application parses the URL, and launches Excel telling to open the document at https://site.lib/workbook.xlsx and then passes 'navigate to specific object' command with #... part of URL as an argument to Excel. In VBA this is done with something like Application.Goto Worksheets("Sheet1").Range("A1").

That clients are 'smart'. Browsers are not.

So the answer is yes, you can create that kind of links to Excel files stored in SharePoint with #...!... notation, but they will only work in context of other Office application.


The URL will be something like:




First create a named range for the table or data on the spreadsheet you want to link to. Now that I think of it I don't think it's necessary. But do it if all else fails. :-)

At the end of your file path add this ?web=1?range='YourWorksheetName' Where YourWorksheetName will be the name of the worksheet or the table range name.

Your final path will look something like this assuming it's an excel you are linking to in a SharePoint data library...



Peter Wangxin's solution worked for me!


  • please add the content from the blog rather than just sharing link.
    – Waqas Sarwar MVP
    Commented Feb 3, 2023 at 17:51
  • While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes. - From Review Commented Feb 3, 2023 at 18:11

Right click on a sheet tab in web version of Excel and there's a menu position which gives you possibility to get the link for specific sheet.


Open the Excel using the browser and Navigate to the sheet (Tab). Then select Share->Copy Link to This Sheet.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.