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

Hi Tim-

You most certainly can, but you're going about it in a way that makes Excel
think you are trying to paste an entire sheet into a single cell. Try this
instead;

Don't bother to copy anything, just Right-Click the tab of the sheet involved.

Choose 'Move or Copy...' form the menu, then select New Book from the list
box. Be sure to put a check in the Copy box & click OK.

Save the new book with whatever name you wish and you're done.

HTH |:)

"Tim" wrote:

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

The question now is, Why if I copy a sheet, and then open a new workbook, the
available resourses error message pops up. THis doens't happen on my home
machine, just at work. I know the work arounds to avoid this when it
happens. One particularly interesting one is to open excel in safe mode and
then try the procedure and it works fine. This leads me to believe one of
the add ins is to blame, but not sure yet.

"Tim" wrote:

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