Powerpoint Paste Link from Excel Truncates Spreadsheet

Anonymous
2016-08-17T14:20:41+00:00

Hello,

I am trying to link a Powerpoint Presentation to an Excel spreadsheet.  I have copied a table in Excel into PowerPoint using the Copy Paste Special -> Paste Link feature.  At first, this looks great.  Updates I make to the Excel Spreadsheet automatically update in PowerPoint and all the formatting looks right.

However, after saving, closing, and re-opening the Powerpoint file, the Spreadsheet has been truncated.  It is missing about 1/2 of a column and about 3 rows.  I tried to update the link, and even to delete the table and re-paste the linked spreadsheet, and nothing seems to work.  It doesn't appear to be an issue with the size, because I copied/pasted just a small table (4x2) as a test and it did the same thing.

Does anyone have any ideas for how to solve this?

Thanks,

Alan

Microsoft 365 and Office | PowerPoint | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

47 answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2017-05-12T10:19:39+00:00

    Wow - thanks - I had to go to 150% to work for me - but problem solved. Thanks

    Was this answer helpful?

    10+ people found this answer helpful.
    0 comments
  2. Anonymous
    2017-08-24T16:05:24+00:00

    Anytime Excel is inserted into PowerPoint whether it is done by link or by embed, it runs the risk of becoming unstable for some reason and it really needs to be addressed by Microsoft.  I have experience the same problem with the Excel table becoming truncated

    • it just sometimes will not "display" up all the selected cells that are copied from excel and pasted as an embed in PowerPoint.  Sometimes it works perfectly, and sometimes it doesn't (instability).  However, I have found that when Excel becomes unstable, I reboot my computer, then select a small section of a different table from Excel and paste it as an embed in PowerPoint.  It usually will display correctly at that point.  Then I go back to the table I actually wanted to embed, select and copy from Excel, then paste and embed - this time it usually works, because now excel is back stable again.  I cannot guarantee that this will work every time for you, but it works for me.  It seems that I have to reset and trick it into doing what I need it to do.

    This sounds crazy and I know it does, but this experiment has worked for me many, many times.

    The bottom line is Microsoft needs to determine why an Excel table becomes unstable in PowerPoint and eliminate the problem.

    Was this answer helpful?

    10+ people found this answer helpful.
    0 comments
  3. Anonymous
    2017-09-08T07:01:28+00:00

    Steve, when half a dozen office users (who know how to embed an object or a link) report an issue then the possibility of a real issue existing is noticeably higher, which requires more investigation. This problem has taken away more than 4 hours of my time trying to update my powerpoint slides.

    I followed instruction given by MCGIG005 and changing display settings to 125% resolved the issue. Now my question is why there is no KB on this issue? If there is, why it doesn't come up as top search results with metadata used as tags?

    Also if I email this deck to others do they also need to change display settings to see all content?

    And please remember details matters to us, paying users, too! Otherwise we could also pet the cat instead of using Microsoft products.

    Thank you!

    Was this answer helpful?

    10+ people found this answer helpful.
    0 comments
  4. Anonymous
    2017-09-14T17:28:07+00:00

    ISSUE!

    1. Highlight Table in excel
    2. CTRL + C
    3. Go to PowerPoint
    4. Click on a slide
    5. Home Tab
    6. Arrow under Paste Icon
    7. Paste Special 
    8. Select Past Link
    9. Highlight Microsoft Excel Worksheet Object
    10. Select OK
    11. Chart is truncated 

    I have also tried multiple ways of coping and multiple ways of pasting as a link.

    The customize your display works but I do not want to have to zoom my screen in every time I want to paste something.

    My coworkers are having the same issue.

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments
  5. Anonymous
    2017-10-14T17:32:36+00:00

    Same issue.

    No explanation of detailed steps are required.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments