How to make Excel 2002 to automatically update worksheet names in hyperlinks?

Hello
How to make Excel 2002 to automatically update worksheet names in
hyperlinks? I added text to worksheet names, and hyperlinks on another
worksheet stopped working. The hyperlinks reference to old worksheet names.
Now, I have to manually change worksheet names in hyperlinks.

Dmitriy

There is no automatic way of doing this. It could perhaps be accomplished
with some coding but you are not missing a secret switch ;-)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Dmitriy Kopnichev" wrote in message
...
Hello
How to make Excel 2002 to automatically update worksheet names in
hyperlinks? I added text to worksheet names, and hyperlinks on another
worksheet stopped working. The hyperlinks reference to old worksheet
names.
Now, I have to manually change worksheet names in hyperlinks.

David McRitchie has posted these:

How about one of these that David McRitchie has posted:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

And one of those bottom two updates nicely when I change the name of the
worksheet.

(The difference between the 2nd and 3rd is the single quotes around the sheet
name--they're required when your worksheet name contains spaces or all numeric.)

Dmitriy Kopnichev wrote:

Hello
How to make Excel 2002 to automatically update worksheet names in
hyperlinks? I added text to worksheet names, and hyperlinks on another
worksheet stopped working. The hyperlinks reference to old worksheet names.
Now, I have to manually change worksheet names in hyperlinks.

--

Dave Peterson