Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel hyperlink problems
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel hyperlink problems
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/comm...c.exc el.misc B2: http://www.microsoft.com/office/community/ B3: en-us/default.mspx?lang=en&cr=US&dg=microsoft.public.exc el.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.. "Linda S" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel hyperlink problems
=HYPERLINK($B$2&$B$3,"friendly name")
oops missed a dollar sign in B3, they make reference fixed / "absolute". "nastech" wrote: 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/comm...c.exc el.misc B2: http://www.microsoft.com/office/community/ B3: en-us/default.mspx?lang=en&cr=US&dg=microsoft.public.exc el.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.. "Linda S" wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel hyperlink problems
None of these have ever been copied or pasted. Once a hyperlink has been
created, it's only used to look-up information. Thanks. "nastech" wrote: =HYPERLINK($B$2&$B$3,"friendly name") oops missed a dollar sign in B3, they make reference fixed / "absolute". "nastech" wrote: 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/comm...c.exc el.misc B2: http://www.microsoft.com/office/community/ B3: en-us/default.mspx?lang=en&cr=US&dg=microsoft.public.exc el.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.. "Linda S" wrote: 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel hyperlink problems
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" "Linda S" wrote: None of these have ever been copied or pasted. Once a hyperlink has been created, it's only used to look-up information. Thanks. "nastech" wrote: =HYPERLINK($B$2&$B$3,"friendly name") oops missed a dollar sign in B3, they make reference fixed / "absolute". "nastech" wrote: 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/comm...c.exc el.misc B2: http://www.microsoft.com/office/community/ B3: en-us/default.mspx?lang=en&cr=US&dg=microsoft.public.exc el.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.. "Linda S" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hyperlink problems with multiple sheet spreadsheet on Intranet | Excel Discussion (Misc queries) | |||
Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
Problems with HYPERLINK in Excel 2002 and 2003 | Excel Worksheet Functions | |||
Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) | |||
Hyperlink Problems | Excel Worksheet Functions |