Lose data when copy and paste from workbook to workbook

A

Akwai

When I do a simple copy and paste of multiple or even 1 cell from a sheet in one workbook to a sheet in another workbook, the data gets cut off - only the first part is pasted. These cells do have quite a bit of text and the cells with limited data seem to paste okay. The cell format is General. Any suggestions???
 
J

Jamal

What version of excel are you using? There are limitations
on the number of characters a cell can have.

Regards

Jamal
-----Original Message-----
When I do a simple copy and paste of multiple or even 1
Click to expand...
cell from a sheet in one workbook to a sheet in another
workbook, the data gets cut off - only the first part is
pasted. These cells do have quite a bit of text and the
cells with limited data seem to paste okay. The cell
format is General. Any suggestions???
 
D

Dave Peterson

do you have both workbooks open in the same instance of excel?

If no, try it with just one instance open. (Open one file, and then File|open
the second).

If you double click on a file in windows explorer and it always opens a new
instance of excel, you may want to change this behavior:

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.

An alternative might be to do:
Try Tools|Options|General|Ignore other applications (uncheck it)
 
Top