Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default picture is too large and will be truncated - Excel 2007

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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default picture is too large and will be truncated - Excel 2007

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

On Mon, 25 Jan 2010 11:21:02 -0800, the_pyewacket
wrote:

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.


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default picture is too large and will be truncated - Excel 2007

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?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why are large reports truncated in Excel? ALPost95Adj Excel Discussion (Misc queries) 1 October 26th 08 01:45 AM
The picture is too large and will be truncated CLR Excel Discussion (Misc queries) 7 February 11th 07 12:49 AM
The picture is too large and will be truncated Dhruba Bandopadhyay New Users to Excel 3 July 21st 06 04:40 PM
The picture is too large and will be truncated Dhruba Bandopadhyay Excel Worksheet Functions 3 July 21st 06 04:40 PM
Picture will be truncated CLR Excel Discussion (Misc queries) 0 June 3rd 05 02:44 PM


All times are GMT +1. The time now is 08:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"