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?