The workaround given by MS says that the number you can do before an erroris dependent on the size of the sheet you are copying.