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?

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?

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?

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

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

There's a setting in excel:
tools|options|Edit tab|Edit directly in cell
You could turn that off to see if your hyperlink works ok.

I always have this turned off (personal preference).

But I did have the same trouble as you with that setting enabled.

If you can't change that setting, maybe you could use the Insert|hyperlink
version (ctrl-k is the shortcut key).

I used this as my link:

c:\my documents\excel\test\book1.xls#sheet3!g15

And xl2003/winXP opened it and went to G15 of sheet3.






The Good Deeds Team wrote:

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


--

Dave Peterson