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: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-04-04T18:22:49+00:00

    Yes! It has to do with zooming. If you go into display settings and set the size of text, apps, and other items to 100%, it should fix the problem. I find that I use ctrl+scroll to zoom in and out fairly often. This apparently messes with the way Office products copy and paste into each other. Hope this helps!

    Was this answer helpful?

    0 comments
  2. 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

  3. Anonymous
    2018-02-14T15:07:18+00:00

    I have had the same problem.  As soon as bring the second external display into play I see the truncation.  I am using a surface pro 4, and it doesn't matter if I connect the external displays directly to the surface, or go thru the docking station.

    This is crazy that to use excel and PowerPoint, or even copying it from an excel tab to an excel tab that I have to change my display configuration.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2018-01-29T22:54:27+00:00

    Same.. had to go to 150%. Weird

    Was this answer helpful?

    0 comments
  5. Anonymous
    2017-12-01T21:39:03+00:00

    Just to log that I have the same issue and it is driving me insane...    I couldn't get any screen size to work.

    Here's another work around.  If you are looking to just paste a picture of the spreadsheet into powerpoint, use the snipping tool.  I think this is a 10.1 function only....

    Press the windows icon and then type 'snipping tool'.   The snipping tool bar will pop up.   Choose the rectangular mode.   This will let you take a snapshot of a section of your screen, and then you can paste that picture into powerpoint using the usual paste picture function in powerpoint.

    Hopefully this is just a temporary fix so you can get some work done....

    Was this answer helpful?

    0 comments