Excel - Excel hyperlink problems

Asked By Linda

29-Oct-07 03:03 PM

I have a spreadsheet with approximately 12,000 entries. All entries are
hyperlinked to .pdf files. Every time I check the spreadsheet, there will be
anywhere from 5-10 hyperlinks that don't work. Either the hyperlink LOOKS
like it's there, but when you click on it, you get "requested filed does not
exist" or it looks like it's there, but there's no response when you click on
it.

Right clicking when the first scenario happens will bring up the shortcut
menu that includes options to edit hyperlink, remove hyperlink or insert
hyperlink. The 2nd scenario brings up the shortcut menu with only "insert
hyperlink."

Does anybody have any ideas what might be happening? The worksheet is used
by multiple city/county entities.

Thank you.

29-Oct-07 07:36 PM

hi, I had a problem with hyperlinks a long time ago, if remember right, some
of problems seemed to be:
- when copying a range / multiple rows of the same hyperlink down, say 10,
20..
then cutting pasting deleting sorting portions of everything all mixed up,
would seem to trash the work I had done.

my answer was to remote portions of the hyperlink to a single location using
AND signs:  "&"  to connection them together.  i.e.:

http://www.microsoft.com/office/community/en-us/default.mspx?lang=en&cr=US&dg=microsoft.public.excel.misc

B2:  http://www.microsoft.com/office/community/
B3:  en-us/default.mspx?lang=en&cr=US&dg=microsoft.public.excel.misc

using the hyperlink function:
=HYPERLINK($B$2&$B3,"friendly name")

should get you back to this page, and be stable;  allows you to do easy edit
etc..

29-Oct-07 07:42 PM

=HYPERLINK($B$2&$B$3,"friendly name")

oops missed a dollar sign in B3, they make reference fixed / "absolute".

29-Oct-07 07:46 PM

None of these have ever been copied or pasted. Once a hyperlink has been
created, it is only used to look-up information. Thanks.

29-Oct-07 07:56 PM

that's fine, but if using a non-function/ formula type hperlink, hyperlinks
can be unstable in ways I can't count..  performing some other / non-related
functions will trash hyperlinks,  to rephrase, they can be "really..  really
unstable"