Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Feb 2002
    Location
    Tennessee USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Clipped Device Independent Bitmap - from Excel (2000 SR 1)

    I copy large excel exhibits into PPT (full page is 80 rows). Have found that all paste options either cut off data - or distort copy significantly. Usually have best results with Paste Special - Device Independent Bitmap (though I don't like the file size). Got a new computer (Windows 2000 SP2) , and now the bitmaps are clipped on right hand side. I get all the Excel cell formating, but the contents in the last column are only half there. Is this a clipboard problem? A ppt problem? Excel problem? Any hints?

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Clipped Device Independent Bitmap - from Excel (2000 SR 1)

    Hi,

    This doesn't deal directly with your problem, but it may give you a better solution than using DIBs, which often look grainy.

    Since your data is coming from Excel, why not insert and Excel worksheet object into your slide, instead of the DIB, and paste the required cells into it. This keeps formatting etc intact, allows enlarging without pixelation, and perhaps best of all, allows you to put formulae such as:
    ='C:MyDocuments[Data.xls]Sheet1'!A1
    into the embedded Excel worksheets that link to the source workbooks (thus being able to update them by simply refreshing the links). You can change the displayed range by scrolling and/or by dragging the small 'handles' at the sides & corners of the object while it is open, depending on what you're trying to achieve.

    Hope this helps
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. #3
    New Lounger
    Join Date
    Feb 2002
    Location
    Tennessee USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Clipped Device Independent Bitmap - from Excel (2000 SR 1)

    I have found that the inserted Excel worksheet object often gets clipped more seriously than any other paste format. In an 80 row range - I am lucky to get 50 or 60 to show in the PPT page. I do like the linkage in the worksheet object. As to pixelation - the DIB shows "fuzzy" on screen, but prints very sharp - and since the format for this document is print - I don't mind the screen display.

  4. #4
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Clipped Device Independent Bitmap - from Excel (2000 SR 1)

    I am not sure how you are getting your picture.
    I tried this way and it seemed to work OK

    Select region to copy in Excel
    Hold down shift and select the Edit menu
    Select Copy Picture...
    Select "As shown on screen" and "Bitmap"
    Went to my slide and pasted in.
    Then had to resize <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    This showed no sign of clipping but I had to shink the picture so much to get it on screen that I could not read it!
    I used an 80 row by 17 col block for the test.

    HTH

    Peter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •