huge data

[vics_roo]

Hello,
I have excel file 600 000 rows, each have 70 columns.

If I use Ctrl+A and paste it to another workbook, the Excel 2013 is crash.
I suggest that insufficient of memory to complete this action

So is there any VBA way to process that huge data ?

Thanks at advance

P.S. The best way to process it as i think - using the database, but for that problem using database is restricted

 

[RickXL]

If you want to copy it all why not just copy the file? In Windows you can copy and paste whole workbooks without opening Excel.

What sort of processing do you want to do on the workbook?

 

[Smitty]

Welcome to the Board!

Is there a reason a database is restricted? With that much data, especially if it's cumulative, it's your best bet.

Or if this is for analysis purposes you might want to look at PowerPivot.