Excel 2000

I have a spreadsheet that utilizes the sumif function
command from another external spreadsheet. If the other
file is open, no problem, the function does its job.
However, when the external file is not open and the dialog
box asks me about updating links I get a value error in
each cell. How do I make this work without opening the
external file?

Thanks in advance.

Dave