Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel -- Excel data copy truncated at 255 characters
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.... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel -- Excel data copy truncated at 255 characters
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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "KunzLeigh" wrote in message ps.com... 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.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
How to Copy and Paste Several Columns of Data into Excel... ? | Excel Discussion (Misc queries) | |||
consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
Copy If Ability for Excel Data | Excel Worksheet Functions | |||
excel data label format special number characters (part 2) | Excel Discussion (Misc queries) |