Hyperlinks
 

I have a Workbook with many spreadsheets in it and have linked column
"A" cells
via hyperlinks to go to the different spreadsheets within the same
workbook.
This works fine.
The problem is, when I sort the data using column "J", it sorts the
spreadsheet
OK but dos'nt sort the hyperlinks with it.
Now when I click on a hyperlink in column "A" it goes to the
spreadsheet which was linked to that cell before I sorted it??
This happens in Office97 & Office XP.
Any clues to resolve this problem would be much appreciated.


--
grahammal
------------------------------------------------------------------------
grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336
View this thread: http://www.excelforum.com/showthread...hreadid=564634

Hyperlinks
 

I'd drop the insert|Hyperlink version of hyperlinnks and use a helper column
using the worksheet function:

=hyperlink()

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

grahammal wrote:

I have a Workbook with many spreadsheets in it and have linked column
"A" cells
via hyperlinks to go to the different spreadsheets within the same
workbook.
This works fine.
The problem is, when I sort the data using column "J", it sorts the
spreadsheet
OK but dos'nt sort the hyperlinks with it.
Now when I click on a hyperlink in column "A" it goes to the
spreadsheet which was linked to that cell before I sorted it??
This happens in Office97 & Office XP.
Any clues to resolve this problem would be much appreciated.

--
grahammal
------------------------------------------------------------------------
grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336
View this thread: http://www.excelforum.com/showthread...hreadid=564634

--

Dave Peterson