[SOLVED] Can’t paste because the Copy area and paste area… [EXCEL]
Q. I cannot determine what is causing the following error:
The frustrating error
Can you help me determine what causes this, I am working with some large Excel spreadsheets and it is driving me mad. Thank you.
-Shelly
A. Hi Shelly! Since you are dealing with large Excel spreadsheets, the problem is likely that you are near the one million row count and that the pasted cells push you over the limit. It is absurd that Excel throws the wrong error message for this problem 🙁 At least knowing this you can hopefully work around the issue!
Best regards,
-J.D.
PS Here is an example spreadsheet that had this same issue, it is a little over 100MB:
Large Excel spreadsheets can sometimes be problematic
Top Search Terms:
- you can\'t paste here because the copy area (65)
- you can\'t paste this here because the copy (58)
- you can't paste here because the copy area (56)
- you can't paste this here because the copy (40)
- you can\'t paste this because the copy area (13)
- copy and paste area aren\'t the same size (12)
- copy and paste area aren't the same size (11)
- you can\'t paste this here because the copy area and paste area aren\'t the same size (10)
- copy area and paste area not same size excel (10)
- we can\'t paste because the copy area (9)
It happens when trying to paste a single cell into a new blank sheet, both .xlxs files.
??
Peter, if it happens with a single cell into a blank sheet, then I do not think the one-million-row explanation from my post fits your case very well. My best guess would be merged cells, protected sheets, or some other workbook-specific issue instead.
What is the solution?
Shubham, in the case I wrote about, the solution was realizing Excel was effectively at the row limit and the paste would have pushed it over. If your sheet is not huge, though, then you may be hitting a different cause.