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?

Excellll
  • 12,847
Caffeinated
  • 461

1 Answers1

-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
  • 25