Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 17 of 17

Thread: Pasting into Powerpoint

  1. #11
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Good point mhguda.

    You might try hyperlinking to an Excel worksheet.

    [ This Message was edited by: Brian from Maui on 2002-05-04 17:15 ]

  2. #12
    New Member
    Join Date
    May 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-04 08:38, Brian from Maui wrote:
    Pigeonhill,

    Exactly what steps are you taking or doing? Someone else may have an idea here.

    Are you highlighting the rows and columns, click copy, go to the PowerPoint slide, then click paste?

    YES !!!!!!

    [ This Message was edited by: Brian from Maui on 2002-05-04 08:44 ]

  3. #13
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    This is a known issue. There are several things that can affect this, as well as workarounds that work; though not any one ALWAYS works:

    1. If Office 97, make sure you've got the latest service release.

    2. If you're centering your page horizontally in page setup of Excel, this can mess up the paste. Other page formatting can affect it too. Try removing any page formatting/reduced pct/Fit-to settings in the Excel file first. I've had users copy those cells and link them to an individual workbook (linked to original) so they could do all that without wrecking their original formatting.

    3. Try selecting cells in Excel, hit Zoom dropdown, choose Selection. Save the file, copy/paste.

    4. But the most common one that works is when your cells start on A1 of the FIRST worksheet. Then Insert-Object-From File and choose the Excel workbook...

    Oh, and it appears MS has something to say about it:

    http://support.microsoft.com/directo...;EN-US;Q285303

    *Microsoft has confirmed this to be a problem.*

    Hmmm...for about 10 years now!! Wish they'd fix it! I did read one time that it's only intended for up to 7 columns.

    Hope this helps either of you!
    ~Anne Troy

  4. #14
    New Member
    Join Date
    Apr 2002
    Location
    Sydney Australia
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try copying the excel sheet, and paste special => unformatted text in powerpoint. You just have to insert tab marks for column starts.

  5. #15
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

  6. #16
    New Member
    Join Date
    May 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks everyone for your ideas re pasting into powerpoint.

    I'm glad it wasn't me being dumb!!!!

    Cheers

    Garry

  7. #17
    New Member
    Join Date
    May 2002
    Location
    New Jersey
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Question on this "old" issue from a newbie: when you say "And yes I have tried resizing the paste window", do you mean the window that opens when you double-click on the object? Pasting goes in as an embedded object, so that means you should be able to edit it in Excel by double-clicking. And THAT means that resizing THAT window will expand or contract (or move to other cells, heaven help us!) the cells you see in PPT, regardless of what you actually copied.
    I am interested in your response (whether you already tried this) because I am teaching this in class tomorrow night, and this is very timely!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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