Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting cells containing hyperlinks
Article ID : 214328 - Hyperlinks are removed or invalid after you sort cells
that contain these hyperlinks in Excel Is there a way to resolve this issue? Or does one have to continually fix the hyperlinks every time a worksheet is updated? That is very time consuming when you have hundresd of links. Microsoft simple says: Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. No hint of a Hot Fix etc. to address the problem. All suggestions are welcome Al |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting cells containing hyperlinks
Don't use the insert|hyperlink version.
Try using an adjacent cell with the =hyperlink() worksheet function. Al wrote: Article ID : 214328 - Hyperlinks are removed or invalid after you sort cells that contain these hyperlinks in Excel Is there a way to resolve this issue? Or does one have to continually fix the hyperlinks every time a worksheet is updated? That is very time consuming when you have hundresd of links. Microsoft simple says: Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. No hint of a Hot Fix etc. to address the problem. All suggestions are welcome Al -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting cells containing hyperlinks
Thank-you for that suggestion but now when I click on the hyperlinks I get
the following message: "Cannot open the specified file." Therefore I cannot test the sorting aspect of this problem I have searched high and low for an explanation of how to fix this error but am finding absolutely nothing. Any ideas? Thank-you Al "Dave Peterson" wrote: Don't use the insert|hyperlink version. Try using an adjacent cell with the =hyperlink() worksheet function. Al wrote: Article ID : 214328 - Hyperlinks are removed or invalid after you sort cells that contain these hyperlinks in Excel Is there a way to resolve this issue? Or does one have to continually fix the hyperlinks every time a worksheet is updated? That is very time consuming when you have hundresd of links. Microsoft simple says: Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. No hint of a Hot Fix etc. to address the problem. All suggestions are welcome Al -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting cells containing hyperlinks
As long as the hyperlinks are still pointing the incorrect location, you won't
be able to click on them successfully. If you want to try to fix them, you may find a routine written by David McRitchie useful. Take a look at David McRitchie's site: http://www.mvps.org/dmcritchie/excel/buildtoc.htm look for: Fix Hyperlinks (#FixHyperlinks) If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm But my suggestion was to delete the existing (incorrect) hyperlinks and use brand new =hyperlink() worksheet functions. Al wrote: Thank-you for that suggestion but now when I click on the hyperlinks I get the following message: "Cannot open the specified file." Therefore I cannot test the sorting aspect of this problem I have searched high and low for an explanation of how to fix this error but am finding absolutely nothing. Any ideas? Thank-you Al "Dave Peterson" wrote: Don't use the insert|hyperlink version. Try using an adjacent cell with the =hyperlink() worksheet function. Al wrote: Article ID : 214328 - Hyperlinks are removed or invalid after you sort cells that contain these hyperlinks in Excel Is there a way to resolve this issue? Or does one have to continually fix the hyperlinks every time a worksheet is updated? That is very time consuming when you have hundresd of links. Microsoft simple says: Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. No hint of a Hot Fix etc. to address the problem. All suggestions are welcome Al -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trouble with Sorting Hyperlinks | Excel Discussion (Misc queries) | |||
Problem sorting cells containing hyperlinks | Excel Worksheet Functions | |||
Hyperlinks and Sorting | Excel Discussion (Misc queries) | |||
Hyperlinks and sorting data | Excel Discussion (Misc queries) | |||
Hyperlinks change after sorting | Links and Linking in Excel |