Hi,

both two spreadsheets are in the same folder.

if both two spreadsheets are open, the cells linked are showing properly, but if close both and then open the destination spreadsheet (not the source file), and enable the link, all the linked cells are showing #REF, however, if i open the source file, then have a look at the destination file, everything comes up.

Is there a way to solve this problem, and make all linked cells up to date when only the destination file is open??

thanks a lot