Excel - Copy large number of rows takes long time

[Ebraham]

Hi,


hi i want to copy around 65000 rows from one workbook to another, this takes a very long time.


Is there any faster way to copy the rows?

 

[FDibbins]

Have you tried, instead of highlighting the entire row, only select up to those columns that you need? So if your last cell is J65000, only select A1:J6500

 

[Ebraham]

yes i tried

It takes approx 6-7mins to get copy and sometimes cannot paste the entiredata(i m partly selecting the data and pasting). is there any otherway

 

[chicagocomputerclasses]

Try this if you need DATA ONLY:

On your new workbook go to
DATA->FROM ACCESS
Change to all file types->find your Excel source file and import the data sheet
Then right click on the imported table and unlink from data source.

Depending on your Excel version this feature may be not available.