Hi,

Unlike Lotus, Excel only likes links when files are open. When creating the
link, have source file open and select the cell to link with, this way the
full path of the file / cell are captured. Using this method does ensure
that when the file that contains the links is open, the option to retain the
link is given.

Rob

"Arnold de Lange" <Arnold de wrote in
message ...
When I link cels to another excel spreadsheet the links stay alive as long
as
the othe sheet is open. If not opened the cell consisting the link show
#VALUE!
How come ?