Unless I have a linked file open it is not giving me the correct result.
Even when I refresh or update values, it is still incorrect, I have to
have the source file open.

Can you please help as it is driving me insane and I am very worried I
will send something out that is very very wrong!

I am using Excel 2003,


--
smcd
------------------------------------------------------------------------
smcd's Profile: http://www.excelforum.com/member.php...o&userid=33625
View this thread: http://www.excelforum.com/showthread...hreadid=533982