Linking a web page to a specific excel tab

Microsoft Excel 2003 (full product)
July 29, 2010 at 10:43:17
Specs: Windows XP
I've researched but had no luck finding an answer.

I'm trying to create a link on a web page to an excel file that targets a specific tab. Below are examples that I have read via my research, which proved to be unsuccessful.

<a href="excelfilename.xls#tabname">

<a href="excelfilename.xls#tabname!A1">

I even tried bookmarking the specific cell with in each tab or defining the name.... but its a no go.

The links work great if I'm linking with in the excel file but its not what I want.

Is there anyway to identify a tab so when I click a hyperlink from a webpage and it opens an excel file, it will target a specific tab?


See More: Linking a web page to a specific excel tab

July 29, 2010 at 10:49:10
Were you planning on having multiple links to different tabs or just a single link to a specific tab?

The reason I ask is this:

If it's a single link to a specific tab, you could put a Workbook_Open macro in the ThisWorkbook to select the desired tab:

Private Sub Workbook_Open()
End Sub

Report •

July 29, 2010 at 10:58:31
It will be multiple links to different tabs.

Report •

July 29, 2010 at 11:16:02
Does this not work:

or this?

If these don't do it for you, but apparently work for others, then it might be time to look elsewhere for your problem.

I don't mean that in a bad way, I just mean that there is usually something else amiss when the standard methods don't work for a single person/workbook/webpage.

Report •

Related Solutions

July 29, 2010 at 11:32:40
haha, belive it or not i've seen both of theses page before during my research. talks about how to define a workbook... however the menu option they give seems to be for an older format of excel. I'm currently using 2007. So this answer does not help me. i went to the insert tab but didn't find anything similar to what the article had said. I've tried this but it didn't seem to work... however, if you look at the last posted date. It was dated for 2002. Which means this probally worked for an older version of excel. possibly 2000?

So I guess the question is... how can I link from a web page to a specific tab in a excel file using the Excel 2007 version.

Report •

July 29, 2010 at 12:34:57
hmm...I was able to find some recent posts in other forums describing the same problem, but no actual solutions.

I'll keep digging.

Report •

July 29, 2010 at 12:38:39
Thank you Derby Dad. I really appreciate your effort in finding a solution for my problem.

Report •

July 30, 2010 at 09:27:21
I have not found my solution yet... but from further research I belive that this is no longer possible.

It seems IE use to open excel files with in the browser. It currently opens excel files in excel.

Hence why it doesn't reconize the archor embeded with in a href.

In other words... because excel was open through the browser it could reconize:

<a href="excelfile.xls#tab1!A1">click here</a>

Now that it opens in excel... it completely disregards the request.

If there is a way, I'm sure it requires some kind of scripting with in excel....

Report •

January 25, 2011 at 08:47:49
I too have the same problem with Excel 2007 files, and have not found a viable solution yet. The links used to work in a previous version (2003) of Excel, but when we upgraded to MSOffice 2007, the links now open the workbook referenced, but not the specific sheet specified in the link using #SheetName!A1.

Report •

February 8, 2011 at 10:11:21
Following up for anyone else who comes looking here like I just did.

The instructions at worked just fine for me. Just follow steps 1-4, and when you save your spreadsheet, it should work just fine.

The point to remember is this: when you make your link, don't use myworkbook.xls#MyWorksheetName - instead, you will define a name in cell A1 of the worksheet you want to open to, and use the link myworkbook.xls#TheNameDefinedInA1

I've never done this with older versions of excel, so I can't speak to whether anything has changed - but this method absolutely worked for me just now.

Report •

Ask Question