Powerpoint linked chart not updating

A very common task you may have is to take a chart you’ve painstakingly formatted and use it with new data.I described a few ways to handle this in Make a Copied Chart Link to New Data.But in Excel 2007, these steps don’t work the same way.

Ideally having a window come up that prompts the users to point to the excel file from which the powerpoint should update everytime. Sub modifylinks() Dim Excel File Dim exl As Object Set exl = Create Object("Excel. Not all of the OLE Objects in my Power Point are Excel charts (some are direct references to cells) which means they don't have the brackets which seems to be causing a problem.Well, knowing the above protocol, you’d think you could copy the worksheet, change the data, and the chart would be fine.And in Excel 2003 this set of steps works great: The new pivot chart (on the copied sheet) retains its link to the pivot table on its parent worksheet, so it updates as soon as the pivot table is refreshed. I have tweaked a couple parts of different codes and have gotten close, the problem I encounter is Excel charts have the file name and worksheet listed twice (i.e. Below is the formula, if anyone can figure out a way to adjust the formula to also update the workbook in brackets to the new file I would greatly appreciate it! Although, I'd suggest your VBA is better than mine looking at your much tidier code!


I tried your code and while it updates the source file it does not capture the cell references leaving the code useless in the specified case. [workbook.xls]Graphs Chart 3) and the formula does not change the second occurrence of the workbook name in brackets. Source Full Name is blank Can you it in yours and let us know what the msgbox shows please?It is not possible to do this in powerpoint 2016 for Mac.



  1. Pingback:

  2. eric   •  

    Then he disappears, never to be heard from again, resulting in a little visit from the Public Security Bureau.

  3. eric   •  

    Women continue to be seated as Gentlemen swap tables just about every 5 minutes.

  4. eric   •  

    Nubiles has built a name for themselves over the years for finding the hottest new talent at their peak of freshness, no tired old pornstars here.

  5. eric   •  

    Gale Harold was a virtual unknown when he was tapped to play Brian Kinney, a successful advertising executive with a blatant disregard for social conventions, in the Showtime adaptation of the popular British drama ...

  6. eric   •  

    In April 2013, CBS renewed the series for an eleventh season after closing one-year deals with Kutcher and Cryer.

  7. eric   •  

    We also provide information and support to concerned friends and family members, teachers, counselors, service providers and members of law enforcement.

  8. eric   •  

    Whether you're searching for gay video chat, teen dating or even teen video chat, you will find it all in this list.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>