picture is too large and will be truncated - Excel 2007

[the_pyewacket]

When copying a medium to large group of cells, the above message is received
as a popup. No error id - just the message in a popup window. Incredibly
aggrevating as I'm copying large amounts of data between spreadsheets. This
doesn't occur in Excel 2003, 2000 or 97.
Any assistance would be appreciated.

 

[Gord Dibben]

I'm just guessing but are you copying form a sheet in one workbook to a
sheet in another workbook?

Sounds like these two books are each running in their own instance of Excel.

Close down one instance and open both in a single instance of Excel.


Gord Dibben MS Excel MVP

 

[idJoe]

I am facing the same problem just like pyewacket, and I am running
only ONE instance of Excel 2007, where the first workbook open another
workbook.
In my case I only use a 100 rows and 3 columns of numeric data to be
used as source data for chart. The first column is a year list, second
is months list (from 1 to 12), and the last column is for values.
The table will look like below:
Year Month Value
2009 1 12345
2009 2 23456
and so on

The message pop ups when I try to close workbook without saving it.
Anybody has solution for this?

 

[DaveUnger]

Hello idJoe,

I am running into the same problem as you are, doing almost exactly what you are doing. After a lot of trial & error, I finally stumbled onto something that worked for me. At the end of my copy/paste procedure, I add a line, something like this: "wk.Cells(1, 1).Copy" or "wk.Range("A1").Copy". This reduces the clipboard size, and seems to solve the problem for me. Not sure why the message comes up in the 1st place, but this seems to be a workaround. Hope this is helpful.

regards,

Dave

I am facing the same problem just like pyewacket, and I am running
only ONE instance of Excel 2007, where the first workbook open another
workbook.
In my case I only use a 100 rows and 3 columns of numeric data to be
used as source data for chart. The first column is a year list, second
is months list (from 1 to 12), and the last column is for values.
The table will look like below:
Year Month Value
2009 1 12345
2009 2 23456
and so on

The message pop ups when I try to close workbook without saving it.
Anybody has solution for this?