Lose data when copy and paste from workbook to workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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???
 
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???
 
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)
 
Back
Top