I have links in my workbook to a field (containing text) in another excel
workbook. If both my destination and source files are both open - the link
works. If only my destination file is open, I only get part of the value of
the linked field. (I'm running Excel 2003). Any suggestions on how I can
have this link function properly, without having to have both workbooks open?