Hyperlinks

[JT]

I have created an Excel document with 7 sheets representing Sunday -
Saturday. Is there some way of inserting a hyperlink (to a word doc) in the
Sunday sheet and then having it appear on the other sheets so that if I
change the link it will change on the other sheets as well or do I have to
insert it in each sheet individually?

Hope I explained this correctly.

Thanks for any assistance

JT

 

[zvkmpw]

I have created an Excel document with 7 sheets representing Sunday -
Saturday.  Is there some way of inserting a hyperlink (to a word doc) in the
Sunday sheet and then having it appear on the other sheets so that if I
change the link it will change on the other sheets as well or do I have to
insert it in each sheet individually?

The following works for me in Excel 2003.

In Sheet1 cell A1, use
Insert > Hyperlink > Existing file or web page
and browse to the file of interest. In the Hyperlink dialog box, leave
the "Text to display" field alone so it shows the hyperlink.

In Sheet2 cell A1, put
=HYPERLINK(Sheet1!A1)

Later, edit the hyperlink in Sheet1 using
[right-click] > Edit hyperlink
and again don't touch the "Text to display" field.

The hyperlink in Sheet2 changed as desired.

 

[Gord Dibben]

In addition to the excellent advice given by zvkmpw

You can group the other six sheets when adding the second formula referring to
1st sheet. =HYPERLINK(Sheet1!A1)

Same formula will be added to all grouped sheets at once.


Gord Dibben MS Excel MVP

I have created an Excel document with 7 sheets representing Sunday -
Saturday.  Is there some way of inserting a hyperlink (to a word doc) in the
Sunday sheet and then having it appear on the other sheets so that if I
change the link it will change on the other sheets as well or do I have to
insert it in each sheet individually?

The following works for me in Excel 2003.

In Sheet1 cell A1, use
Insert > Hyperlink > Existing file or web page
and browse to the file of interest. In the Hyperlink dialog box, leave
the "Text to display" field alone so it shows the hyperlink.

In Sheet2 cell A1, put
=HYPERLINK(Sheet1!A1)

Later, edit the hyperlink in Sheet1 using
[right-click] > Edit hyperlink
and again don't touch the "Text to display" field.

The hyperlink in Sheet2 changed as desired.

 

[Pete_UK]

But remember to Ungroup the sheets once you are finished, otherwise
you might get some nasty duplicated surprises.

To ungroup, right-click a sheet tab and click on Ungroup sheets.

Hope this helps.

Pete

In addition to the excellent advice given by zvkmpw

You can group the other six sheets when adding the second formula referring to
1st sheet.  =HYPERLINK(Sheet1!A1)

Same formula will be added to all grouped sheets at once.

Gord Dibben     MS Excel MVP

The following works for me in Excel 2003.

In Sheet1 cell A1, use
 Insert > Hyperlink > Existing file or web page
and browse to the file of interest. In the Hyperlink dialog box, leave
the "Text to display" field alone so it shows the hyperlink.

In Sheet2 cell A1, put
 =HYPERLINK(Sheet1!A1)

Later, edit the hyperlink in Sheet1 using
 [right-click] > Edit hyperlink
and again don't touch the "Text to display" field.

The hyperlink in Sheet2 changed as desired.- Hide quoted text -

- Show quoted text -

 

[Gord Dibben]

Good point Pete.

I usually add that caveat but am gettiong more forgetful as age creeps up.


Gord

But remember to Ungroup the sheets once you are finished, otherwise
you might get some nasty duplicated surprises.

To ungroup, right-click a sheet tab and click on Ungroup sheets.

Hope this helps.

Pete

In addition to the excellent advice given by zvkmpw

You can group the other six sheets when adding the second formula referring to
1st sheet.  =HYPERLINK(Sheet1!A1)

Same formula will be added to all grouped sheets at once.

Gord Dibben     MS Excel MVP

I have created an Excel document with 7 sheets representing Sunday -
Saturday. Is there some way of inserting a hyperlink (to a word doc) in the
Sunday sheet and then having it appear on the other sheets so that if I
change the link it will change on the other sheets as well or do I have to
insert it in each sheet individually?

The following works for me in Excel 2003.

In Sheet1 cell A1, use
 Insert > Hyperlink > Existing file or web page
and browse to the file of interest. In the Hyperlink dialog box, leave
the "Text to display" field alone so it shows the hyperlink.

In Sheet2 cell A1, put
 =HYPERLINK(Sheet1!A1)

Later, edit the hyperlink in Sheet1 using
 [right-click] > Edit hyperlink
and again don't touch the "Text to display" field.

The hyperlink in Sheet2 changed as desired.- Hide quoted text -

- Show quoted text -

 

[JT]

Thanks for everyone's help.

Good point Pete.

I usually add that caveat but am gettiong more forgetful as age creeps up.


Gord

But remember to Ungroup the sheets once you are finished, otherwise
you might get some nasty duplicated surprises.

To ungroup, right-click a sheet tab and click on Ungroup sheets.

Hope this helps.

Pete

In addition to the excellent advice given by zvkmpw

You can group the other six sheets when adding the second formula
referring to
1st sheet. =HYPERLINK(Sheet1!A1)

Same formula will be added to all grouped sheets at once.

Gord Dibben MS Excel MVP



I have created an Excel document with 7 sheets representing Sunday -
Saturday. Is there some way of inserting a hyperlink (to a word doc)
in the
Sunday sheet and then having it appear on the other sheets so that if
I
change the link it will change on the other sheets as well or do I
have to
insert it in each sheet individually?

The following works for me in Excel 2003.

In Sheet1 cell A1, use
Insert > Hyperlink > Existing file or web page
and browse to the file of interest. In the Hyperlink dialog box, leave
the "Text to display" field alone so it shows the hyperlink.

In Sheet2 cell A1, put
=HYPERLINK(Sheet1!A1)

Later, edit the hyperlink in Sheet1 using
[right-click] > Edit hyperlink
and again don't touch the "Text to display" field.

The hyperlink in Sheet2 changed as desired.- Hide quoted text -

- Show quoted text -