"Excel will return up to 255 characters from a closed workbook."

dave, that's the limitation i needed to know.

--


Gary


"Dave Peterson" wrote in message
...
Excel will return up to 255 characters from a closed workbook.

If you have a cell in a closed workbook that has less than that and you're
not
seeing all of it returned via your formula, make sure the
columnwidth/rowheight
is adjusted so you can see more.



Gary Keramidas wrote:

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

--

Dave Peterson