Disapeared Hyperlinks in Excel 2000

T

Twister_7777

Hi,

We are worling on W2K and with Office 2K. In an excel document, there are several hyperlink (around 700 perhaps) and after a certain moment, several hyperlinks in the same column went corrupted and all changes to a point to a specific cell in another row.

Did you ever see that ? Is there a way to reverse that situation ? Any info or help will be greatly appreciated.

Patrick
 
D

Dave Peterson

I've never seen this, but I do recall some posts that suggest too many
hyperlinks in a worksheet can cause problems. But that was a longgggggg time
ago and I'm not sure that it ever referred to xl2k.

But I know that when I need lots (never near 700, though) hyperlinks, I'll use
the =hyperlink() worksheet function--not the insert|Hyperlink feature.

Any chance you have a backup you can copy from?
 
T

Twister_7777

Hi Dave

Thank you for replying. I have backup but there problem exist since too much time to go back. You speak about a =hyperlink() option in excel. Is it available in Excel W2K ? I cannot find it. Would you be kind enough to give me an exemple of a formula that will create a link to a web site or to a document

Thank again for helping me ! Wish I can help you a day

----- Dave Peterson wrote: ----

I've never seen this, but I do recall some posts that suggest too man
hyperlinks in a worksheet can cause problems. But that was a longgggggg tim
ago and I'm not sure that it ever referred to xl2k

But I know that when I need lots (never near 700, though) hyperlinks, I'll us
the =hyperlink() worksheet function--not the insert|Hyperlink feature

Any chance you have a backup you can copy from

Twister_7777 wrote
 
D

Dave Peterson

=HYPERLINK("http://www.microsoft.com","click here to go to MS")

or even
=hyperlink(a1,b1)
if you've got the right stuff in a1

Or to point a file on a drive:

=HYPERLINK("C:\My Documents\word\myDoc.doc")
 
D

Dave Peterson

And one way to extract those URL's from a hyperlink created via Insert|Hyperlink
is with a userdefinedfunction.

Here's one that may help:

Option Explicit
Function GetURL(Rng As Range) As String
Application.Volatile

Set Rng = Rng(1)

If Rng.Hyperlinks.Count = 0 Then
GetURL = ""
Else
GetURL = Rng.Hyperlinks(1).Address
End If
End Function

So if you had a hyperlink in A1, you could put =getURL(a1) in that adjacent
cell.

Be aware that if you change the hyperlink, then this formula cell won't change
until your workbook calculates.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
D

David McRitchie

The HYPERLINK Worksheet Function is a function not an option.
It is available in Excel 97 and up.

Some examples are in
http://www.mvps.org/dmcritchie/excel/sheets.htm

If you use the right click hyperlink, you can assign several cells
to the same hyperlink at the same time. Perhaps deleting
or clearing something messed up the others. There are some
strange things that happen when you delete the hyperlink from
one of the cells. For reliability you would assign them one at
a time.
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Twister_7777 said:
Hi Dave,

Thank you for replying. I have backup but there problem exist since too much time to go back. You speak about a =hyperlink()
Click to expand...
option in excel. Is it available in Excel W2K ? I cannot find it. Would you be kind enough to give me an exemple of a formula
that will create a link to a web site or to a document ?
Thank again for helping me ! Wish I can help you a day !

----- Dave Peterson wrote: -----

I've never seen this, but I do recall some posts that suggest too many
hyperlinks in a worksheet can cause problems. But that was a longgggggg time
ago and I'm not sure that it ever referred to xl2k.

But I know that when I need lots (never near 700, though) hyperlinks, I'll use
the =hyperlink() worksheet function--not the insert|Hyperlink feature.

Any chance you have a backup you can copy from?
Click to expand...
after a certain moment, several hyperlinks in the same column went corrupted and all changes to a point to a specific cell in
another row.
 
Top