Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Some columns don't change when I sort
Im working with a document index that includes hyperlinks to PDF files.
When I have the documents sorted by number (which is the order in which the index appeared when I added the hyperlinks), the hyperlinks work fine. But when I sort by document date, it seems that the hyperlinks dont change their relative locations; instead, they appear to be locked into their particular rows. Obviously, I need the hyperlinks to correlate to the documents, not the fixed row numbers. Any solution? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Some columns don't change when I sort
They are supposed to sort properly.
Can you paste a few rows here and send the file to me? "lawhoo" wrote: Im working with a document index that includes hyperlinks to PDF files. When I have the documents sorted by number (which is the order in which the index appeared when I added the hyperlinks), the hyperlinks work fine. But when I sort by document date, it seems that the hyperlinks dont change their relative locations; instead, they appear to be locked into their particular rows. Obviously, I need the hyperlinks to correlate to the documents, not the fixed row numbers. Any solution? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort by color: Is there an easy way to sort columns or rows in EX | Excel Worksheet Functions | |||
sort by two columns ends up with wrong sort in 2nd col | Excel Discussion (Misc queries) | |||
Ascending Sort formula, change to neg #: descending sort.. | Excel Discussion (Misc queries) | |||
Sort command does not sort some columns? | New Users to Excel | |||
data sort is not including all columns in sort | Excel Discussion (Misc queries) |