I have used the sumif function with remote cell references. When I open
the worksheet and click yes to update cell refences it returns errors in
the cells but if I open the other worksheet the references update.

Does anyone know how to use sumif and allow the remote references to be
updated without opening the worksheet that contains the references.

Thanks.....


--
hennis
------------------------------------------------------------------------
hennis's Profile: http://www.excelforum.com/member.php...o&userid=26207
View this thread: http://www.excelforum.com/showthread...hreadid=395133