picture is too large and will be truncated - Excel 2007

  • Thread starter Thread starter the_pyewacket
  • Start date Start date
T

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.
 
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
 
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?
 
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

idJoe said:
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?
Click to expand...
 
Back
Top