Some functions don't work on closed files.
There are usually alternate approaches available.

Post some of your formulas.
--

Regards,

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

"Paul" wrote in message
...
Why will my destination file only update if the source file is open? If the
source file is closed, I get the error message: Unable to read file. Please
help!