text limit using a vlookup

I'm using the vertical lookup function to fill in cells in a spreadsheet and
for whatever reason part of the text gets cut off at the end. There are a
good 20+ characters left off. When I open both files (the looker upper and
the looker frommer) all of the text is filled in.

Why does this happen, and what may be a solution?

You'll only get 255 characters back when the "sending" workbook is closed. If
you open the sending workbook (and recalc), you'll get the all the text.

I don't know a workaround.

(It's not just =vlookup()'s, either.)

Dave D wrote:
>
> I'm using the vertical lookup function to fill in cells in a spreadsheet and
> for whatever reason part of the text gets cut off at the end. There are a
> good 20+ characters left off. When I open both files (the looker upper and
> the looker frommer) all of the text is filled in.
>
> Why does this happen, and what may be a solution?

--

Dave Peterson