I don't think you 'tupid'...but maybe your Excel is haunted. I cannot
replicate your system's behavior.

Try doing the SUM on Sheet2 in L1 (or some other empty cell)
=SUM(E1:K1) and just reference that cell on Sheet3 (=Sheet2!L1) and see
what happens. Make sure you don't have multiple sheets selected.

What happens?

b


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=380884