Could be the cells with #N/A are linking to cells with 255 characters?
Not much you can do about it if you want the full text to appear -
except to open the source workbook.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup