Tags: article, excel, internet, microsoft, msdn, picture, searched, software, truncated

The picture is too large and will be truncated

On Microsoft » Microsoft Excel

3,648 words with 3 Comments; publish: Wed, 04 Jun 2008 15:57:00 GMT; (30646.88, « »)

The picture is too large and will be truncated

This is what I get in Excel 97. I searched on the internet and only could

find a MS KB article referring to Office 2000. It also appears that this is

some kind of bug... that has been in the Office suite since 97 and still is

in Office 2003, etc.

I have VBA code copying and pasting text rows. There are no image picture

involved. But when I get this message, I do not get any reference of where

it was in VBA code.

How can one find out more about this bug?

All Comments

Leave a comment...

  • 3 Comments
    • I have got this error when Copy/Paste as Picture, never when working with

      ranges/rows etc.

      NickHK

      "Dhruba Bandopadhyay" <dhruba.bandopadhyay.excel.todaysummary.com.hotmail.com> wrote in message

      news:egFNII0qGHA.1852.excel.todaysummary.com.TK2MSFTNGP03.phx.gbl...

      > The picture is too large and will be truncated

      > This is what I get in Excel 97. I searched on the internet and only could

      > find a MS KB article referring to Office 2000. It also appears that this

      is

      > some kind of bug... that has been in the Office suite since 97 and still

      is

      > in Office 2003, etc.

      > I have VBA code copying and pasting text rows. There are no image picture

      > involved. But when I get this message, I do not get any reference of where

      > it was in VBA code.

      > How can one find out more about this bug?

      >

      #1; Wed, 04 Jun 2008 15:58:00 GMT
    • Does anyone know how to contact Microsoft Office development team, the ones

      who made Excel 97?

      Am not requesting a bug fix to their 1997 program, but at least tell us why

      or what makes this error message come up.

      "Dhruba Bandopadhyay" <dhruba.bandopadhyay.excel.todaysummary.com.hotmail.com> wrote in message

      news:egFNII0qGHA.1852.excel.todaysummary.com.TK2MSFTNGP03.phx.gbl...

      > The picture is too large and will be truncated

      > This is what I get in Excel 97. I searched on the internet and only could

      > find a MS KB article referring to Office 2000. It also appears that this

      > is some kind of bug... that has been in the Office suite since 97 and

      > still is in Office 2003, etc.

      > I have VBA code copying and pasting text rows. There are no image picture

      > involved. But when I get this message, I do not get any reference of where

      > it was in VBA code.

      > How can one find out more about this bug?

      >

      #2; Wed, 04 Jun 2008 15:59:00 GMT
    • [quote=lucas]By copy and paste text rows do you mean entire rows of a

      spreadsheet with text in the cells? Please post the code you are using for

      this operation.[/quote]

      This is the only piece of code that does copy/paste:

      Set MoldRow = oSheet.Rows(CurRow + TableRow - 2)

      MoldRow.Copy

      oSheet.Rows(CurRow + TableRow - 1).PasteSpecial Paste:=xlPasteFormats,

      Operation:=xlNone, _

      SkipBlanks:=False, Transpose:=False

      So as you can see it's copying a whole entire row from 2 rows above, to 1

      row above.

      Any ideas on how to suppress the error bug message?

      "Dhruba Bandopadhyay" <dhruba.bandopadhyay.excel.todaysummary.com.hotmail.com> wrote in message

      news:egFNII0qGHA.1852.excel.todaysummary.com.TK2MSFTNGP03.phx.gbl...

      > The picture is too large and will be truncated

      > This is what I get in Excel 97. I searched on the internet and only could

      > find a MS KB article referring to Office 2000. It also appears that this

      > is some kind of bug... that has been in the Office suite since 97 and

      > still is in Office 2003, etc.

      > I have VBA code copying and pasting text rows. There are no image picture

      > involved. But when I get this message, I do not get any reference of where

      > it was in VBA code.

      > How can one find out more about this bug?

      >

      #3; Wed, 04 Jun 2008 16:00:00 GMT