Links to closed worksheet

Y

yanf7

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
am updationg my file, the links return Value error.
Is there anything I can do to stop this from happening
 
Top