linked values not displayed unless source file open

i have an excel sheet with cells linked to cells in another seperate excel
file.

Excel will not show the values unless I have the source file open.

this always used to work with the source file closed. Now the target file
shows #value.

this is a major nuisance if there are 7 or 8 linked files!

please help.


Sandy

There are some worksheet functions that don't work with closed workbooks.

=indirect(), =countif(), =sumif()

are a few.

If you share your formula, you may find that there's an alternative that you can
use.

Sandyc wrote:
>
> i have an excel sheet with cells linked to cells in another seperate excel
> file.
>
> Excel will not show the values unless I have the source file open.
>
> this always used to work with the source file closed. Now the target file
> shows #value.
>
> this is a major nuisance if there are 7 or 8 linked files!
>
> please help.
>
> Sandy

--

Dave Peterson