Share via

Powerpoint - paste link from Excel Worksheet object

Anonymous
2020-02-04T15:08:53+00:00

Hello,

I am using the Paste Special --> Paste Link  --> Microsoft Excel Worksheet Object and I would like to make sure that the paste result has the highest image quality. Is there anyway to check if the image resulting from the paste special operation is Enhanced Metafile?

Thanks in advance,

Alexandra Almeida

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
Answer accepted by question author
  1. John Korchok 224.3K Reputation points Volunteer Moderator
    2020-02-04T16:04:59+00:00

    By default, smaller selections paste at 100%, which gives the best display. Other than that, there are no options to increase visual quality. Links use OLE and OLE has always displayed poorly, especially when resized.

    1 person found this answer helpful.
    0 comments
Answer accepted by question author
  1. Steve Rindsberg 99,086 Reputation points MVP Volunteer Moderator
    2020-02-04T16:27:07+00:00

    When you paste-link an Excel object, PPT internally stores a link to the Excel object AND a metafile representation of the object.  Used to be you could simply ungroup pasted/paste-linked charts to break the connection to the original XL object and leave just the metafile representation behind.  That's been broken for several versions, so instead, you can copy the XL object, then paste-special, as EMF to get an EMF representation of it if you like.

    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. 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

  2. John Korchok 224.3K Reputation points Volunteer Moderator
    2020-02-04T15:17:22+00:00

    As you can see in your screenshot, the format is not Enhanced Metafile, it is Microsoft Excel Worksheet Object. If you're pasting links, that's all that's available. To get EMF format, your would have to embed the file by choosing the default Paste option.

    0 comments
  3. Anonymous
    2020-02-04T15:28:12+00:00

    Thank you for your answer, John.

    When  I paste a link as a link to the worksheet object it does not paste an object with a link, it is more like a linked picture of the object. What I was trying to figure out is if we can set the quality of the image that we are seeing.

    0 comments