Is there an easy fix to this copy/paste into Excel error?

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?

Adel

Posted 2012-08-09T20:27:04.497

Reputation: 401

Answers

-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

kamalo

Posted 2012-08-09T20:27:04.497

Reputation: 25

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 - http://superuser.com/questions/366468/what-is-the-maximum-allowed-rows-in-a-microsoft-excel-xls-or-xlsx

– Adel – 2012-08-09T20:45:29.513

2

Correct here's the updated referenced link are you stil having the error?

– kamalo – 2012-08-09T20:51:34.467

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 – 2012-08-09T20:53:12.673

The link applies to Excel 2003. here are the new limits

– SeanC – 2012-08-09T21:38:50.330

Asked: 2012-08-09T20:27:04.497

Viewed: 1 719 times

Active: 2012-08-13T17:03:13.507