How do you link to a specific worksheet from another Excel Worksheet without VBA Code or Macros?

Your zones are: Microsoft Visual Interdev, Web Development Software, Server Applications

You ask: How do you link to a specific worksheet from another Excel Worksheet without VBA Code or Macros?
I think you should consider changing zones to Excel...

In answer to your question: simply insert a hyperlink to the file you want to link to in a cell of the file from which you want to open this file. When you click the link, the file will open.

How do I change zones to Excel? Thanks for your answer but it always goes back to a diffrent sheet no matter what.

I found the answer at this site: ExcelBanter forum

Complete the link with: ..\filename.xlsx#worksheetname!A1, where worksheetname is the name of the worksheet and A1 is the cell where you want to land!


 

Sorry, tried it, it didn't work for me.

Please note:

Try
 ..\filename.xlsx#worksheetname!A1
 
and, if the worksheet name contains a space, put it in quotes
 ..\filename.xlsx#'worksheet name'!A1
 
or use a defined name
 ..\filename.xlsx#rangename
 

Also, it may not work in older versions (Office 2003 and earlier) but I could't really know this from your question since you didn't mention it. If this is the case, please see: Hyperlink to specific worksheet in Excel (go to the bottom of the page).

Thanks moderator!

I'm sorry paulsuave it didn't work for me. I have Excel 2003.

Unless I misunderstand the question, you put something like this into an Excel formula:

=Sheet2!A1

And easy way to do this is to put an equal sign (=) into the formula bar then click on the sheet you want at the bottom left corner, then click on the cell you want, then press the enter key and you're done.

If you are trying to span across workbooks, you must have the workbook open and put the name of the workbook in brackets; you may also need quotes if the workbook or worksheet contain special characters:

='[My Open Workbook.xls]SomeSheet'!$C$40

Please, did you read the answer from Frank Sandrin. February 7th 05, 07:01 PM at the bottom of the page of the link I posted above (ID: 35891384 Author: paulsauve Date:01/06/11 08:28 PM)?

It seems that you set up the Excel document first by creating an "anchor", then you can refer to in in a second file.

@rspahitz, Thanks but no go. The link always jumps to the last worksheet I saved in the workbook no matter what I do. I also saw your earlier comment about the workbook being open, which defeats the whole purpose of creating a hyperlink to jump to the file.

First, did you change the name of the worksheet in the formula?  You have to change Sheet2 to the name of your desired sheet.
This works perfectly for me from Sheet1 of a new workbook using Excel 2010.  Are you using a different version?

And maybe you need to reword your request because from reading it, it appears that you simply want to have a cell in one workbook give a way for the user to jump to a different cell in the same workbook, but on a different sheet.

I've requested that this question be deleted for the following reason:

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

Based on the title and original question, it seems that it has some archival value and is answered with this ID:

36019446