I am having a problem with the clipboard - i am copying a large set of
data from one workbook to another and am not getting consistent
results with the data that comes out of the clipboard.

I have two workbooks open - lets call them OLD and NEW - i go to a
sheeta in OLD and highlight the data from A1:T1144. I Control C to
copy the data and switch to the NEW workbook - I select sheeta in the
new workbook and select cell A1 - i paste the data using ctrl v - this
is where it gets strange . If the OLD workbook is open resulting data
in the NEW wb is exactly as in the OLD wb.

However if i close the OLD wb before i paste the data into the NEW wb
i lose 2 columns of data - As i close the OLD wb i get a message
asking if i want to keep the data in the clipboard and i answer yes
to keep the data. Also if i try to do a paste special i have the
option of copying the data as text or unicode only -

Any thoughts as to why this happens

I am not certain of the technical reasons but I am well aware of the problem.
I think it is a memory thing. When the 2 workbooks are open, I think that all
that is really in memory is the pointers to the source data but when you
close the source, all of the data needs to be placed in memory and if
insufficient memory then not all is copied.

The answer is as you have said; keep the source workbook open until you have
pasted.

--
Regards,

OssieMac


"vitorjose" wrote:

I am having a problem with the clipboard - i am copying a large set of
data from one workbook to another and am not getting consistent
results with the data that comes out of the clipboard.

I have two workbooks open - lets call them OLD and NEW - i go to a
sheeta in OLD and highlight the data from A1:T1144. I Control C to
copy the data and switch to the NEW workbook - I select sheeta in the
new workbook and select cell A1 - i paste the data using ctrl v - this
is where it gets strange . If the OLD workbook is open resulting data
in the NEW wb is exactly as in the OLD wb.

However if i close the OLD wb before i paste the data into the NEW wb
i lose 2 columns of data - As i close the OLD wb i get a message
asking if i want to keep the data in the clipboard and i answer yes
to keep the data. Also if i try to do a paste special i have the
option of copying the data as text or unicode only -

Any thoughts as to why this happens

.

I would try using pastespecial. I suspect that the Pastespecial options
are going to show up differently when the workbook is opened verses
closed. Ossie is probably right that when the workbook is opened it is
point to the old workbook which has the formating of the cells
accessable. When you cclose the workbook the either the formating is
being eliminated or the options that paste is using is different.

Microsoft programs have algorithms built in the make decision
automatically. These decision making algorithms don't always make the
decisions you want them to make. The problem may be that the paste
option is changing when the workbook is closed. The default condition
for a paste is to paste everything when using just excel. When you
close the workbook the source workbook credentials are lost. So the
algorithm doesn't know if the data came from a workbook or maybe word
document. So the paste operation picks the best formating style to
perform that paste operation.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=178994

Microsoft Office Help