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: Newest
Most helpful Newest Oldest
  1. 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
  2. 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
  3. Anonymous
    2017-04-25T18:32:35+00:00

    I was able to resolve the issue for me by resetting my display settings to 125%

    Not sure the reason this worked or if it was a coincidence, but it is worth a shot.

    Changing the zoom and customizing the display solved my problem as well!

    Nothing else worked

    Was this answer helpful?

    30+ people found this answer helpful.
    0 comments
  4. Anonymous
    2017-02-28T19:38:06+00:00

    I was able to resolve the issue for me by resetting my display settings to 125%

    Not sure the reason this worked or if it was a coincidence, but it is worth a shot.

    Was this answer helpful?

    50+ people found this answer helpful.
    0 comments
  5. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more