Tim

Sounds like user is doing a SHIFT + EditCopy Picture.

That will give user the "truncate etc." message.

Hit CTRL + A(twice in 2003) and EditCopy.

Open a new book and should be no problem pasting.


Gord Dibben Excel MVP

On Wed, 27 Apr 2005 13:25:41 -0700, Tim wrote:

Thanks for the alternative, unfortunatley I am dealing with a user who does
not like to learn new ways, and claims she never had a problem copying a
sheet then selecting file new.

"CyberTaz" wrote:

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