I have s/s#1 which uses vlookup to locate data in a seperate file s/s#2,
and returns the data to s/s#1. This is working ok.

Assuming I have closed all files, and I open s/s#1 and select NO to
update links, if I now change the data I am searching for the result is
an error condition, (even if the data does actually exist in s/s#2).

Some spreadsheets I have created have this problem and some don't. I
suspect there is a setting which allows you to cache the data from the
linked spreadsheet.

Any suggestions?

Scott


--
scott.auer
------------------------------------------------------------------------
scott.auer's Profile: http://www.excelforum.com/member.php...o&userid=23700
View this thread: http://www.excelforum.com/showthread...hreadid=375906