linked values not displayed unless source file open

[Guest]

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]

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.