I did this exactly the way your descibed, but it does not seem to work, if I
click on the cell, all that happens is I get into the edit mode.

This is want is not working:

=HYPERLINK('S:\ACCOUNTING\Budgets\Budgets\FY2005\C luster 1 OOP\10 Office of
the President\[101 Office of the President Budget.xls]Sheet 1'!$A$1,"Click
Here")

If I move the [], and add double quotes, it works like this, but it does not
include the cell I want to move to:

=HYPERLINK("[S:\ACCOUNTING\Budgets\Budgets\FY2005\Cluster 1 OOP\10 Office of
the President\101 Office of the President Budget.xls]","Office of the
President")

If I position the [] in front of and behind the file name, it says it cant
find the file.

I can't figure out how to add the cell location to this formula







"Dave Peterson" wrote:

I like to have excel do the heavy lifting for me.

I'd open that workbook and then build a formula that points to C4 of that
worksheet.
(Just type = and point to C4 of that worksheet)

Then close the workbook
I got something like this:
='C:\My Documents\excel\[book2.xls]Sheet1'!$C$4

Then to make it a hyperlink, I just put some stuff at the beginning and end:

=HYPERLINK('C:\My Documents\excel\[book2.xls]Sheet1'!$A$1,"clickme")

Notice the position of the []'s.

The Good Deeds Team wrote:

Hyperlinks worked well -

I used this hyperlink

=HYPERLINK("[S:\ACCOUNTING\Budgets\Budgets\FY2005 Budget\OOP\10010 Budget
Ofc of the President.xls]Sheet 1'!$C$4","Office of the President")

The part of the formula Sheet 1'!$C$4 gives me an "Reference is not vaild
error"

Do you know how to fix this part?

"Carole O" wrote:

Check out the hyperlink option. First make up your "Index" page, listing the
names of the other tabs. Select a cell next to the first tab, right click,
select hyperlink, and go to the first tab, and select the cell you want the
cursor to land in. Do this with each item on your index page. You might
also want to hyperlink from each tab back to the Index page. You can also
hyperlink to other workbooks in the same way.

HTH,
Carole O

"The Good Deeds Team" wrote:

Is there a way select an "index" page of a spreadsheet when you first open a
spreadsheet that would show, in a list, all the tabs in the workbook, and let
you select the workbook by clicking on the option.

Would you be able to link to other workbooks and tabs

Currently the tabs across the bottom work, but if I have a lot of
worksheets, it is cumbersome

Do you know what is the maximum number of workseets?

This seems like it may be a more commonly asked question, is there a sample
I could download and look at?



--

Dave Peterson