Copy sheet to new workbook

[Guest]

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

 

[Guest]

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.

 

[Guest]

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 |:>)

 

[Guest]

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 |:>)

 

[Gord Dibben]

Tim

Sounds like user is doing a SHIFT + Edit>Copy Picture.

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

Hit CTRL + A(twice in 2003) and Edit>Copy.

Open a new book and should be no problem pasting.


Gord Dibben Excel MVP

 

[Guest]

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.