Copy>PasteSpecial>Values Takes Forever!

[Dazzawm]

I have a file that has a lot of data 40 columns by 30000 rows and have some formatting in it. When I Copy>PasteSpecial>Values it takes forever almost to the point of freezing. What can I do to speed it up please. Is there a macro that will do it quicker?

 

[TiaXL]

I have a file that has a lot of data 40 columns by 30000 rows and have some formatting in it. When I Copy>PasteSpecial>Values it takes forever almost to the point of freezing. What can I do to speed it up please. Is there a macro that will do it quicker?

get a better PC ? no but seriously I dont think so save maybe copy paste in sections rather than the whole data set at once.

 

[diddi]

turn off auto calculate...

 

[Dazzawm]

turn off auto calculate...

How please?

 

[GlennUK]

I have a file that has a lot of data 40 columns by 30000 rows and have some formatting in it. When I Copy>PasteSpecial>Values it takes forever almost to the point of freezing. What can I do to speed it up please. Is there a macro that will do it quicker?

Are you saying that you are copying and pasting 1.2 million cells in one go?

 

[diddi]

check your help. i am using 2003 and its different

 

[Dazzawm]

Are you saying that you are copying and pasting 1.2 million cells in one go?

I guess so! Didn't really look at it like that. I guess that explains why!

 

[moonfish]

In case you were still wondering, in excel 2007 you can disable calculations under:
Office button > Excel Options > Formulas. You can toggle Workbook Calculation at the top of the page to manual.

 

[diddi]

but autocalculate is whats holding it up.

in vba it is

application.calculation=xlmanual

do stuff

application.calculation=xlautomatic

 

[diddi]

@moonfish
thx. i'm still in the dark ages. lol