This can still be done, Tim. The only difference from previous versions,
AFAIK, is that to select the sheet to be copied click the Select Sheet button
(gray box right above the Row Numbers), then copy as usual.

Create the new book, but select the sheet in the same way (using the Select
Sheet button) _before_ pasting.

The other technique just offers more options & flexibility. I understand
your point, though. My grandfather trashed 4 automatic transmissions because
he insisted on shifting gears just like he used to in his '48 Packard. :)

Good Luck |:)

"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