This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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
A family of Microsoft presentation graphics products that offer tools for creating presentations and adding graphic effects like multimedia objects and special effects with text.
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.
I had the same issue and solved it by simply changed the display to 150%.
Thanks.
INSANE.
I thought I was losing my mind trying to fix this. No one seemed to understand. When I saw this - I thought you posted in the wrong feed.
This worked!
Same problem - Surface Pro 4 ported into LG monitor,tried 125%, 150% and 200%, each progressively made it slightly better but even at 200% still at least 50% of what I was copying was truncated out of the image. I checked settings on the surface pro - tried various display settings in terms of resolution as well as zooming. I also fixed the magnification back to 100% but I still can't copy and paste. I'm guessing based on all of this feedback it has to do with the size of my screen which is in essence a double monitor in one. I use split screen feature. I even turned that off in hopes that would help but nope. This is very frustrating as this is a feature I use on a daily basis for my client work - I'm going to be relegated back to my small surface pro screen until there is a fix.
Same problem - Surface Pro 4 ported into LG monitor,tried 125%, 150% and 200%, each progressively made it slightly better but even at 200% still at least 50% of what I was copying was truncated out of the image. I checked settings on the surface pro - tried various display settings in terms of resolution as well as zooming. I also fixed the magnification back to 100% but I still can't copy and paste. I'm guessing based on all of this feedback it has to do with the size of my screen which is in essence a double monitor in one. I use split screen feature. I even turned that off in hopes that would help but nope. This is very frustrating as this is a feature I use on a daily basis for my client work - I'm going to be relegated back to my small surface pro screen until there is a fix.
Ellen, I feel your pain. When I replied the other day - this display setting above worked. On Monday, it did not.
I copied the excel info, pasted special, as worksheet object. It comes in fine.
Not sure about you, but it is only after it is pasted and I edit the worksheet and return to the slide that it truncates.
I'm not sure if you can tag someone here..., but perhaps @JohnKorchok John Korchok can shed some light on this issue. He's been extremely helpful to me on other ppt issues.
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.