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 No comments

47 answers

Sort by: 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 No comments
  2. Anonymous
    2018-10-02T18:55:07+00:00

    I'm running Office 365 with 2 external monitors and ran into the same issue.

    I tried different combinations of adjusting text size between the 2 monitors and only the 125% setting on both monitors eliminated the problem of truncation (on cells and charts).

    While this is a good fix, it's very frustrating given I'd prefer the 100% setting and I've lost a lot of available real estate to do productive work since everything is larger.

    If anyone has a permanent fix, I'd love to hear it!

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments