Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

When I attempt to paste a large spreadsheet (from a DB, ~90,000 rows) into Excel, I keep getting this error:

Microsoft Excel is waiting for another application to complete an OLE action

enter image description here

I know there's a clipboard buffer area, but not much else. If I upgrade my computer's RAM, will it fix these types of errors?

share|improve this question

1 Answer 1

Microsoft Excel 2010 has a maximum of 65,536 rows per worksheet. I would export your database in two sections then transfer to excel. referenced from here

share|improve this answer
    
Hey my friend, thanks a lot! One small correction though, Excel 2010(my version of it) has actually been upgraded - it's now about 1 mil - superuser.com/questions/366468/… –  Adel Aug 9 '12 at 20:45
2  
Correct here's the updated referenced link are you stil having the error? –  kamalo Aug 9 '12 at 20:51
    
Hey, yeah I still am.. I'm not sure what but I'll try breaking it up as you suggested! I'll let you know what happens :) –  Adel Aug 9 '12 at 20:53
    
The link applies to Excel 2003. here are the new limits –  Sean Cheshire Aug 9 '12 at 21:38

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.