Help with Clipboard

[vitorjose]

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

 

[OssieMac]

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.

 

[joel]

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

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