external named range problem
 

I have workbook1 with formulas using named ranges in external
workbook2. This worked fine until I accidentally deleted the named
ranges in the external workbook. I put ranges back correctly and now
formulas will not work unless external workbook2 is open at the same
time as workbook1. Anyone have any ideas. Really irritating. Any
advice is appreciated. Thanks a lot

JKC


--
JKC
------------------------------------------------------------------------
JKC's Profile: http://www.excelforum.com/member.php...o&userid=31166
View this thread: http://www.excelforum.com/showthread...hreadid=519803