How are you retrieving that value?

Is the "sending" workbook open or closed?

If you're using a formula to retrieve a value from a closed workbook, then
you'll see that 255 limit. But if you open the "sending" workbook, then
recalculate, you'll see all the text.

Marissa wrote:

Okay, it isn't as bad as I originally thought. It turns out that each cells
seems to have a 255 character limit when it comes to copying data from other
sheets. Is there any way to lift this?

"Marissa" wrote:

Greetings, Excel Community. I hope you can help me with this one.

I was typing some notes in an Excel Spreadsheet, which made for some really
jam-packed cells. However, when I came back to look over it, half my
information was gone, cut short at the 1.5 line mark. Is there anything that
could cause this, and how do I fix it?

--

Dave Peterson