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)