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: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2017-02-06T14:44:11+00:00

    I also have had this issue pasting Excel rows and columns into PowerPoint.  I am taking the following steps:

    (1) Select rows and columns in Excel.  Right click -> copy.

    (2) In PowerPoint, Right click -> Paste Options Embed.

    (3) Only a subset of the rows and columns appears.  

    This also happens if, in step 2, I choose Right Click -> Paste Options Picture.

    If I choose Paste Options Keep Source Formatting, then the complete set of rows and columns appears, but I cannot size it smaller.

    None of the links you have supplied address, or solve, this problem.

    Was this answer helpful?

    5 people found this answer helpful.
    0 comments
  2. Anonymous
    2017-02-16T16:30:58+00:00

    Did anyone ever figure out the solution? I'm having the same issue now. Here are the two main instances I'm having issues with:

    1. Pasting an excel table as an image into Word, Outlook emails, or OneNote - the image is always cut off on the side/ bottom, regardless of selection.
    2. Editing an embedded spreadsheet in PowerPoint - similarly cut off. I've tried several solutions that I've read in the threads - nothing has worked. I've even uninstalled and reinstalled office.

    Please help!!

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Steve Rindsberg 99,176 Reputation points MVP Volunteer Moderator
    2017-02-16T16:51:05+00:00

    As you've seen, several people have had this problem, but none of the regulars here have been able to reproduce it, and unfortunately w/o reliable means of reproducing the problem, MS has nothing to go on if they want to fix it.

    If anyone can provide *exact* and *detailed* steps that produce the problem every time, and include Windows and Office versions, one of us at least can try to repro the problem.

    For Windows version:

    Click Start button, rightclick Computer and choose Properties.

    Take a screenshot of the screen that appears.

    Be sure to either resize the screen to hide the activation code first.

    For Office/PowerPoint version:

    Start PowerPoint

    Choose File | Account (if Office 2013 or higher) or File | Help (if Office 2010)

    Take a screenshot of the screen that appears.

    Include the screenshots in your reply here or upload them to OneDrive/etc and include a link to them here.

    Was this answer helpful?

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

  5. Anonymous
    2017-02-16T18:03:09+00:00

    I got an email notice that K_B_GSOrg had posted detailed steps and screenshots, but it's not showing up here, and all the images are broken.

    Big thumbs up.

    Hello Benjamin_Birney_2017, 

    A thread that you are following on Microsoft Community has received a reply from K_B_GSOrg. 

    Title: Powerpoint Paste Link from Excel Truncates Spreadsheet

    Reply:

    Hi,

    I’d be glad to provide exact and detailed steps which produce the problem as this has become very frustrating for me and I would like a solution.

    Here is my Windows version:

    Here is my PowerPoint version:

     Here are the steps for the paste as image issue:

    1. I copy the selection in excel
    2. I paste image into Outlook/ Word/ OneNote and the selection is cut off

    Outlook:

    Word:

    OneNote:

    Read this reply on Microsoft Community.

    Was this answer helpful?

    0 comments