Excel --> Excel data copy truncated at 255 characters

K

KunzLeigh

I've got a client who was copying text from one worksheet to another,
where the text was being truncated at 255 characters. Both worksheets
were created using Excel 2002. It works fine on my PC with the same
spreadsheets and same version of Excel. I couldn't figure out the
problem for the life of me.

My client figured it out on her own. The problem? She's using dual
monitors, and was copying from a spreadsheet on one to a spreadsheet
on the other. Once she tried doing it without going across monitors,
the text was no longer truncated.

If that don't beat all....
 
J

Jon Peltier

Is there a separate instance of Excel on each monitor? It's probably a
matter of copying from one Excel instance into the Windows clipboard, then
into the other Excel instance. Copying from one worksheet window to another
within one instance of Excel doesn't launder the clipboard contents through
the Windows clipboard.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Why is Excel truncating my text to 255 characters? 2
Help merging worksheets with more than 255 characters... 5
Make Table Query Truncating Memo Field at 255 Characters 2
Cells in Embedded Excel Object truncated to 255 characters 1
crystal report to excel 2
255 Character Limit for Linked Excel data 1
How do I recover text that was truncated/ deleted in Excel? 1

Top