[SOLVED] Can’t paste because the Copy area and paste area… [EXCEL]
Q. I cannot determine what is causing the following 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:
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)