Excel Hyperlinks - internal links

[Selvie Krishna]

To my hero,


My hyperlinks degrade. They have the error "Reference is
not valid" eventhough the hyperlink worked previously.
I am creating a resource spreadsheet. To search this
spreadsheet I have created a network of internal
hyperlinks. The links are to different cells on the same
worksheet and on other worksheets within the workbook.
The hyperlinks all work fine, even after closing the file
and reopening it later. For some reason, the links
are "corupted?" I do not change the location of the file
(the location should be irrelevent if the links are
internal) and have not relocated the cells, so why are the
links errored? What can I do to resolve this? Should I
move the file to Word (this is a file that will be used by
many employees so it needs to work consistanly)
HELP! I have had to rework the hyperlinks several times. I
can not determine why the links become errored. Could it
be that the file being saved on a network has anything to
do with it?

Thank you thank you thank you to anyone who can help me
with this.

Selvie

 

[Dave Peterson]

How did you create the hyperlink?
Insert|Hyperlink or did you use the worksheet function =hyperlink().

I've never had any trouble with the =hyperlink() function. (In fact, it's the
hyperlink of my choice!)

David McRitchie posted this and it might help you:

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

 

[Selvie Krishna]

I inserted the hyperlink by right clicking and selecting
hyperlink. All of the specs were inserted using the
window that pops up.

 

[Dave Peterson]

I'm not sure what "degraded" means--except that they're not working.

If you can't find the cause, maybe using the worksheet formula would be an
option.

 

[David McRitchie]

Hi Selvie,
It would probably help you find out what happened it you
posted what the line content is before it gets messed up
and after it gets messed up.

Cells can be blue and underscored looking like hyperlinks, but
have no hyperlink inside.

If you have a bunch of hyperlinks assigned in one selection
and delete one of them, I believe you can end up with all
of them deleted.

What version of Excel and what operating system.

There is one thing to watch out for in HYPERLINK Worksheet
Functions and that is what is inside double quotes is not going
to change. I prefer them, but read the comments on my page.
http://www.mvps.org/dmcritchie/excel/sheets.htm#hyperlinks

 

[Dave Peterson]

And if turns out that those hyperlinks are actually gone, but the formatting
still makes it look like they're still there:

Select your range
format|Style|Normal
(or anything but hyperlink)

This won't get the links back, but will make it look like regular text.

Hi Selvie,
It would probably help you find out what happened it you
posted what the line content is before it gets messed up
and after it gets messed up.

Cells can be blue and underscored looking like hyperlinks, but
have no hyperlink inside.

If you have a bunch of hyperlinks assigned in one selection
and delete one of them, I believe you can end up with all
of them deleted.

What version of Excel and what operating system.

There is one thing to watch out for in HYPERLINK Worksheet
Functions and that is what is inside double quotes is not going
to change. I prefer them, but read the comments on my page.
http://www.mvps.org/dmcritchie/excel/sheets.htm#hyperlinks
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

I'm not sure what "degraded" means--except that they're not working.

If you can't find the cause, maybe using the worksheet formula would be an
option.