View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default The picture is too large and will be truncated

Just a suggestion........I would try performing the same operation from
another computer if possible....and preferably even a different "drop" off
the LAN.....see if the problem is the same.....if this new attempt works,
then the problem lies with the first computer, if not, then probably with the
file.....at least this provides one step of isolation..

hth
Vaya con Dios,
Chuck, CABGx3



"Scooter Anderson" wrote:

Hi there!
I'm getting this exact same error message when I try to copy a range of
cells into a new, blank spreadsheet. The source file resides on a network
drive and the size is 27.5 MB. The same thing happens even when the source
file resides on the hard drive. I select the cells (i.e., Columns A-AV and
Rows 1-100) , hit "Copy", hit "File, New". I get the error msg at this
point. Once I hit "OK" on the error msg, I can then hit "Paste" and the data
will show up. If I select a larger amount of cells (i.e. Columns A-AV and
Rows 1-1000), hit "Copy", hit "File, New", I will get the error msg twice,
then this twice: "Excel cannot complete this task with available resources.
Choose less data or close other applications." Once I hit "OK" both times,
then I can hit "Paste" and get the data. I tried the resolution suggestion
below, and it had no effect. By the way, I'm running XP & MS Office Pro 2003
on a Dell GX-620 with 3.2 GHz, 1 GB RAM, 75 GB HD with 48 GB free, connected
to a network. Excel is installed on the HD.

Any suggestions?
Thanks in advance!
Scooter
----------------------------------------------------------------------------------
"CLR" wrote:

Hi All............
I developed a fairly large XL97 file with macros that has been used for two
months by 5 users. One user just got a new computer with WinXP and XL2k.
Every time she opens this file now, she gets the error message "The picture
is too large and will be truncated". The file is on a network and still
works fine for everyone else. And, this computer will open another large
Excel file with macros without giving the error message. Any ideas please?

Vaya con Dios,
Chuck, CABgx3