Help with Clipboard

V

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
 
O

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top