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-08-25T10:08:57+00:00

    I have the same problem and my two Dell monitors are connected to my HP laptop via a Docking station.

    Both connections use a DVI to DisplayPort adapter. What helped me was to change one of the connections to VGA. It might be a adapter (DVI to DisplayPort) issue or a dual DVI issue. 

    Currently I have one monitor connected through VGA connection and the other one DVI to DisplayPort and problem is solved.

    I hope it helps.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2018-07-10T04:43:00+00:00

    I have just fixed this on a Surface Pro by changing the resolution and size of text settings back to the recommended levels in Setting / Display.

    Many times I have encountered truncation of spreadsheets when copying from Excel and pasting as an image (in any Office app). This time I changed the resolution once and some of the truncated fields returned. Then I changed the resolution and text size again, back to recommended, then restarted. After this pasted images included everything that was in the copy. Normally I have the Surface Pro set at a lower resolution and larger text size to make it easier to read. I also at times use a second screen that also had different settings again.

    Was this answer helpful?

    0 comments