I encounter similar problems, sporadically though. I too am curious for an
answer. Thanks for posting Beth!

George

"Beth S" wrote:

I have a link in a formula to an external spreadhseet. I'm getting an error
unless the source workbook is open. I've never run into this probelm before.
Any suggestions to fix so I don't have to always open the source?