picture is too large and will be truncated - Excel 2007


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

Advertisements

G

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
 
I

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

Advertisements

Joined
Apr 8, 2010
Messages
3
Reaction score
0
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top