Linked cells showing #REF when source file is not open

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

Originally Posted by vlady

what formulas did you used.

I used VLOOKUP, so the source file is like a lookup table.

Hope this explains.