Thanks for the reply.

Some users will be working with the spreadsheet off-line so always having to
open the workbook is not an option (I wouldn't mind if you could open the
workbook, choose not to update the links but still see the full text but that
doesn't work either). Equally I'd prefer not to have less text in the source
workbook.
Since my original post I have found a programmatic way round this that I
could use to copy the text from the source worksheet if (and only if) its
available. See http://www.j-walk.com/ss/excel/tips/tip82.htm. But I'd prefer
to avoid embedding macros in the results sheet if possible.