+ Reply to Thread
Results 1 to 5 of 5

Remove Error when copy Excel pie chart to power point

  1. #1
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    696

    Remove Error when copy Excel pie chart to power point

    Hi,

    I have created a macro to copy Excel Pie Chart to Powerpoint. unfortunately, there is error message once the PowerPoint Application is closed.


    Please Login or Register  to view this content.
    Appreciate your help to resolve the problem

    error.jpg

    here is my workbook.
    Attached Files Attached Files
    Last edited by Faridwahidi; 07-06-2015 at 08:53 PM.

  2. #2
    Forum Contributor
    Join Date
    07-07-2014
    Location
    ericbartha.com
    MS-Off Ver
    2016 Professional
    Posts
    126

    Re: Remove Error when copy Excel pie chart to power point

    Does the the macro work except for the error?

    If so, try putting
    Please Login or Register  to view this content.
    at the very begining. Just be sure to switch it back to true at the very end.

    Edit: I wasn't paying attention and typed the wrong funtion. Try the updated one.
    Last edited by ericbartha; 07-06-2015 at 02:00 PM. Reason: Updated with correct funtion

  3. #3
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: Remove Error when copy Excel pie chart to power point

    Hi ericbarta,

    The macro works except for the error message.

    I have already tested with Application.DisplayAlert or ScreenUdating. both seems does not work to remove the error message.

  4. #4
    Registered User
    Join Date
    04-09-2012
    Location
    New Jersey
    MS-Off Ver
    Excel 2010
    Posts
    66

    Re: Remove Error when copy Excel pie chart to power point

    First of all, Run PowerPoint in safe mode and follow these steps:

    1. Click on File Tab
    2. Go to Option->Add-Ins
    3. On the Manage menu, select COM Add-Ins
    4. Disable the COM Add-Ins if it is available in the list.
    5. Now normally open the PowerPoint File.

    I hope it will help you.

  5. #5
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: Remove Error when copy Excel pie chart to power point

    Hi Steve,

    I have opened in safe mode but I found no item COM Add-Ins. So, there is nothing to be disabled. The stupid error/bugs make my life in trouble.

    did you download my attachment and run at your end? would you get the same thing?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Resize copied Chart from Excel to Power Point
    By LPrenici in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-17-2014, 08:54 AM
  2. Copy graph from Excel to Power Point & update it automatically
    By zuppi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-06-2012, 10:19 AM
  3. Power Point Chart linked to Excel Chart
    By pr4t3ek in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 09-24-2009, 11:33 AM
  4. copy data from excel to power point
    By iscar_marius in forum Excel General
    Replies: 8
    Last Post: 02-09-2009, 08:20 AM
  5. [SOLVED] Copy multiple charts from Excel to Power Point
    By Genef in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-01-2005, 10:07 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1