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