i have a client that gave me 2 workbooks. 1 has some descriptions in column
b. the other has some formulas that use the descriptions.

so one of their formula might be ='[workbook.xls]sheet'!$B$3

only partial text will populate the cell unless the workbook with the
descriptions is actually loaded. i know it's not a cell length issue, some
of the text is less than 100 characters.

so, it the cell shows partial text, i then load the description workbook,
the cell immediately contains all of the information from B3

anyone know what would cause this? i am thinking it may be some sort of
corruption.
--


Gary