If I select all of sheet1 from a workbook and select copy, then open a new
workbook I get the following error messages:

"The picture is too large and will be truncated"
and
"Excel can not complete the tasks with resources. Choose less data or close
other applications."

After clicking ok 4 times the new work book opens and you are allowed to
paste. If you have the 2nd workbook open before you select all copy, no
error message. If you use the "move or copy..." method then no problems
either.

Why can't you copy a sheet and open a new workbook?

Using Excel 2003 with XP