Links to closed worksheet
 

Hello.
I have define names that are linking to the closed worksheets.
When the source is open everything is fine, but when it is closed and I
am updationg my file, the links return Value error.
Is there anything I can do to stop this from happening?


--
yanf7
------------------------------------------------------------------------
yanf7's Profile: http://www.excelforum.com/member.php...info&userid=19
View this thread: http://www.excelforum.com/showthread...hreadid=566661