Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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 – SeanC Aug 9 '12 at 21:38

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .