Hi everyone -

Ran into something I haven't run into before and I'm sitting here
scratching my head wondering what I can do now...even after posting the
question in the charts group...

I've got a table in Excel 2000. I've got it formatted across 27 columns
and 80 rows and it is just the right size to print properly. It does so
as well: the print range is just fine. Hard copy is just fine as well.

But when I try to copy this perfectly acceptable print range as a
picture (i.e. Shift+Edit, Copy Picture, Picture As Printed), Excel hits
me with an error message: Picture Is Too Big and Will Be Cut.

And it does exactly that. It cuts the bottom off of the picture of the
table.

If I remove some rows (ca 6 or so), then I can copy it as a picture,
but when I resize it in the destination, it's distorted: that's why I
had those rows in there to begin with!

This is really, really weird, since we've been using this method to
transfer tables from one workbook to another (for production purposes)
for at least two years now, and have never run into this message
before.

Anyone have any idea what this might be and if there is a work-around?

Thanks in advance

John

As Shown on Screen and Picture are the recommended options. There is some
stretching with As Printed that could be causing the 'Too Big' problem with
the copy.
Mike F
wrote in message
oups.com...
Hi everyone -

Ran into something I haven't run into before and I'm sitting here
scratching my head wondering what I can do now...even after posting the
question in the charts group...

I've got a table in Excel 2000. I've got it formatted across 27 columns
and 80 rows and it is just the right size to print properly. It does so
as well: the print range is just fine. Hard copy is just fine as well.

But when I try to copy this perfectly acceptable print range as a
picture (i.e. Shift+Edit, Copy Picture, Picture As Printed), Excel hits
me with an error message: Picture Is Too Big and Will Be Cut.

And it does exactly that. It cuts the bottom off of the picture of the
table.

If I remove some rows (ca 6 or so), then I can copy it as a picture,
but when I resize it in the destination, it's distorted: that's why I
had those rows in there to begin with!

This is really, really weird, since we've been using this method to
transfer tables from one workbook to another (for production purposes)
for at least two years now, and have never run into this message
before.

Anyone have any idea what this might be and if there is a work-around?

Thanks in advance

John

Hi Mike -

Thanks for the reply.

The problem with As Shown On Screen is resolution and artifacts. For
instance, the original is shown on screen in page-break preview, and
copying As Shown On Screen shows then the border of the page-break
preview, i.e. an artifact from the screen comes over with the picture.
On the target sheet the picture of the table is then surrounded by a
blue line that has to be removed by hand. As Printed avoids this
problem entirely and increases the resolution to 1200 dpi, up from the
72 or so from "As Shown On Screen". Makes the picture bigger, but in
this day of multiple hundred GB drives for the price of a good lunch in
Manhatten, not really a consideration any more.

I've resolved the problem by resizing the tables in question, but it is
for us rather odd, since we've been doing this via VBA code for quite a
while without any trouble. This time I'm doing it by hand to work on a
prototype report, and it's the first time I'd ever seen that sort of
message...

Thanks!

John