solution is to stop automatically calculate formulas in the options
menu.
manually calculate the links after filtering with f9


--
Vliegveld
------------------------------------------------------------------------
Vliegveld's Profile: http://www.excelforum.com/member.php...o&userid=13208
View this thread: http://www.excelforum.com/showthread...hreadid=272748