Excel hyperlink problem after sorting

V

Victor Delta

I sort one of my Excel 2002 spreadsheets by data in the columns. I recently
added hyperlinks to the data in one of the columns and then, to my horror
and disbelief, discovered that when I resorted the data the hyperlinks no
longer matched their original cells!

Does anyone know a way round this problem please?

V
 
C

Clif McIrvin

Victor Delta said:
I sort one of my Excel 2002 spreadsheets by data in the columns. I
recently added hyperlinks to the data in one of the columns and then,
to my horror and disbelief, discovered that when I resorted the data
the hyperlinks no longer matched their original cells!

Does anyone know a way round this problem please?

V


How are you sorting? It sounds like you might be using the auto-filter
(xl2003 was where I began, I'm guessing 2002 is similar) -- and your new
hyperlinks column is outside of the autofilter definition.

The solution is to recreate the autofilter including the new column.
 
V

Victor Delta

Clif McIrvin said:
How are you sorting? It sounds like you might be using the auto-filter
(xl2003 was where I began, I'm guessing 2002 is similar) -- and your new
hyperlinks column is outside of the autofilter definition.

The solution is to recreate the autofilter including the new column.

No, just sorting using the standard A-Z sorter with all populated cells
selected. (I couldn't believe it either!).

V
 
C

Clif McIrvin

Victor Delta said:
No, just sorting using the standard A-Z sorter with all populated
cells selected. (I couldn't believe it either!).

V


That runs me out of ideas, unless you're somehow using a formula with
indirect addressing.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top