Powerpoint Paste Link from Excel Truncates Spreadsheet

Solution: as the issue appeared recently, I uninstalled ALL MS Office updates I could (December 13th back to October 4th 2017; the system did not allow to uninstall some), restarted the computer, and the problem's gone. I can embed or link the worksheet in PowerPoint, edit, etc.

System: Windows 10 home 64b, MS Office 2007 Enterprise 32b.

Unfortunately, I do not know which update was the culprit as there were too many of them to test every one, and not installing the security updates does not seem like a great long term solution, so still waiting for ms to fix the problem.

On the other hand, the oldest posts about this problem date from way back so ms has ignored the problem for years. Motto: because they can!

I faced the same problem today. Working on Lenovo X260 notebook connected (via workstation) to Dell display. Read all the thread above and found that what solves problem for me is just opening lid of notebook at the time I am copying/pasting the chart from Excel to Powerpoint 2016. You don't have to do it to update the link - it works even if lid is closed. Ugly workaround, but helps until MS will fix the problem.

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....

Hi All,

I have had this problem (in fact I still do) and found the following workaround.

I noticed that this only happened once in a while. 

Here is the (my) trigger: Having more than one screen connected to the PC at the time of copying or interacting with the linked image.

So:

If I disconnect the PC from the Dock, I get everything working as it should.

If I then reconnect to the dock, the images look fine. BUT. When I try to interact with them. (e.g. click on/move them or the cells they are linked to),  the error comes back.

I can then save the workbook, disconnect from the dock and open the workbook again and they show up just fine.

I have NO idea why this happens.

I have two screens running. If I open the lid on the laptop, the error still exists.

Hope this helps

And it does this even if I copy one cell from Excel.