The picture is too large and will be truncated.
Posted by Artem on April 27, 2001 12:17 PM
I am trying to copy a range of cells as picture from Excel into Word. Of course, if the size of the range is too large the message:
"The picture is too large and will be truncated."
My questions are:
1. How large should the selection be for this message to appear? I guess it depends on the size, formatting, etc. so maybe someone knows the limit in bytes after which the picture is truncated.
2. Is there a way to control this mesasge from VBA?
Basically i'm trying to do this thru VBA: if the selection copied as picture is too large to be copied entirely at once, then i would breakup selection in 2 parts and copy them one by one.
Posted by bob on June 01, 2001 12:37 PM
It's an error in Excel that's dated back at least to 1997.
I have no idea what causes it. Somedays it never raises it's ugly head, at other times it happens everytime I try to past more than 32 cells.
Y'know, it would really be nice if MS concentrated on fixing their old errors before adding new features to Office.
http://ftp.sas.com/techsup/download/sasnotes/jmp.txt
search for "truncate"
