What formulas are you using?

Some functions *can* work on closed files, while others cannot.

For example:
Sumif and Countif and Indirect *cannot*, while the array set-up of =Sum(If
... .) *can*.

Post some of your formulas.
--

Regards,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

wrote in message
ups.com...
Hi All,

We're running 2003 and when I open files with external references, it
can't update them unless they are open on my machine. The files are
on a network - any reason why they won't update if the files are
closed? If this is normal, is there a work-around?

Many thanks,

Thomas.