Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort excel spreadsheet with hyperlink
I have a spreadsheet with hyperlinks in column A. The path in the hyperlink
for each row refers to the contents in column B with a relative reference. When trying to sort the spreadsheet, if column A is not included in the sort range, then the hyperlink still works correctly by pointing to the correct row. However, if column A is included in the sort range, the hyperlink treats the reference to column B as absolute and points to where the original cell in column B is located after the sort. For example, the hyperlink in column A in row 2 refers to the contents in column B row 2, the hyperlink in column A in row 3 refers to the contents in column B row 3, etc. When sorting and not including column A, the hyperlink for row 2 still refers to row 2 in column B. This is what is wanted. However, if column A is included in the sort, the hyperlink for row 2 points to row 4808 in column B where the original row 2 contents are located after the sort. This is not correct. Is there any way to be able to sort and include column A? There will be many users accessing this spreadsheet and sorting it. Which means there is a very good chance the spreadsheet will be messed up. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I insert a 2-3 page Excel spreadsheet as an object in MS Wo | Excel Discussion (Misc queries) | |||
problem with opening hyperlink in excel 2000 | Links and Linking in Excel | |||
How to hyperlink pdf files in excel spreadsheet | Excel Discussion (Misc queries) | |||
My hyperlink in an excel spreadsheet will not save. | Excel Discussion (Misc queries) | |||
How do I sort letters before numbers in Excel? | Excel Discussion (Misc queries) |