i've never used that function before but this worked for me
=HYPERLINK([Book2]Sheet1!$E$56,"E56")
*edit* beaten to the punch
--
MDubbelboer
------------------------------------------------------------------------
MDubbelboer's Profile:
http://www.excelforum.com/member.php...o&userid=36330
View this thread:
http://www.excelforum.com/showthread...hreadid=563434