Copy/Paste Runtime error 1004: Selection Too Large

Question

In Excel 2007 I have worksheet with about 40 columns and 1 row.

When I highlight the entire row, then copy down 100 rows, everything is fine.

If I copy down to about 5000 rows, everything remains fine.

If I copy down beyond 5000 rows, I get a RunTime 1004 error: Selection Too Large

This is incredible because in Excel 2003, I did not have this problem.

I could copy that 1 row of 40 columns down to nearly 60,000 rows without problem.

Any help/advice is greatly appreciated!

Answer 1

Instead of selecting the complete row, select only the 40 columns and 1 row data.

than check pasting it.

Becasue if you use the complete row, it utilises the complete resources till the last column and that may be the reason your getting this error.

Answer 2

Since you are getting a runtime error this is in a macro?  If so just repeat the copy paste N times where N is the number of times you need for you particular process. You can do 5000 rows at a time and repeat that as many times as necessary. 

For I = 1 to 10

' my copy process

' some sort of offset command

Next I

---

If this answer solves your problem, please check Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers, Shane Devenshire

Answer 3

Steps that you can try to resolve the issue:

1. Clear the temp folder.

Click ‘Start’ > ‘Run’ > Type ‘%temp%’ (without Quotes) in the ‘Run’ box and click ‘Ok’. Now select all the files and folders and delete them.

2. Clear the clipboard data.

Click ‘Start’ > ‘Run’ > Type ‘clipbrd’ in the ‘Run’ box and click ‘Ok’. Now click ‘File’ > ‘Delete’ and ‘Yes’ to confirm.

Answer 4

When you say you highlight the entire row, do you mean the entire row of the worksheet?

If so, I suggest you copy only from the 40 columns that contain data.

For a 2007-format workbook in 2007 an entire row has 16384 cells, rather more than the 256 cells in a 2003-format workbook. 

16384 * 5000 is over 80 million cells.