0

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?

-2

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

4
  • 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/… 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 :) Aug 9 '12 at 20:53
  • The link applies to Excel 2003. here are the new limits
    – SeanC
    Aug 9 '12 at 21:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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