PowerPoint 2016 automatically resizing charts pasted as metafiles

I draw charts in Excel and paste them into PowerPoint presentations, typically as Enhanced Metafiles, which has never posed me a problem with previous versions of PowerPoint.

However, in the latest version when I paste a chart as a Metafile / Enhanced Metafile its height / width become ~30% larger than the Excel original.  Why? This does not happen when it is pasted in as a PNG / JPEG / GIF / Bitmap - the dimensions stay the same.

This problem does not apply in Word 2016 - the paste sizes are the same regardless of format

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.

I have the same problem, i'm using vbscript to export images from a Qlikview workbook to powerpoint, and since we upgraded to office 365 it makes the images larger for seemingly no reason. This is so frustrating. 

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Hi Ziobro,

We could totally understand your frustration about encountering the issue. While you encounter the issue when you are using script to export images in PowerPoint, I would like to suggest you focus on this thread for proper handling, whose category is Office  / PowerPoint  / Microsoft Office Programming  / Office 2016.

Thanks for your understanding.

Yoga

-------------------------------------------------
If you feel a reply works for you, please kindly vote or mark it as it will be beneficial to other community members reading this thread.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Actually this has NOTHING to do with code it's a bug.

You can check this simply by inserting a rectangle (or any shape) MANUALLY copy and then paste special as an EMF.

The size will be totally different. (For me in 2010 the size is the same)

For slides copy and pasted on a single slide we use this code. You may be able to adapt

Sub fixbug()
    Dim oshp As Shape
    Dim osld As Slide
    Set oshp = ActiveWindow.Selection.ShapeRange(1)
    Set osld = oshp.Parent
    oshp.Copy
    With osld.Shapes.PasteSpecial(ppPasteEnhancedMetafile)(1)
        'correct size
        .Width = oshp.Width
        .Height = oshp.Height
    End With
End Sub

www.pptalchemy.co.uk

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

I am also facing the same issue in Office 2016  Copying Excel Chart using "CopyPicture" and it resizes larger than the actual size in PowerpOint paste as a Enhanced meta file.

sujeet

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.

 
 

Question Info


Last updated July 15, 2020 Views 4,711 Applies to: