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