+ Reply to Thread
Results 1 to 2 of 2

Dynamic chart in Excel doesn't update in PowerPoint after close/reopen, even with Refresh

  1. #1
    Registered User
    Join Date
    10-31-2013
    Location
    Omaha, NE
    MS-Off Ver
    Excel 2010
    Posts
    2

    Dynamic chart in Excel doesn't update in PowerPoint after close/reopen, even with Refresh

    **Update Using Office 365 for this**

    I have a dynamic chart, whose data range is defined by the offset function, with the X and Y data points for the chart defined as named ranges. This works great. I pasted this chart into Powerpoint, maintaining the file links. The data automatically updates in both Excel and PowerPoint when I change the data in Excel.

    HOWEVER, after closing and reopening PowerPoint, the chart no longer refreshes. Note that performing the same actions on a chart with a static range has no problem updating after closing/reopening PowerPoint.

    Any advice on this? Some things I've though about, but haven't been able to execute:

    1) Redefining the range in PPT with a VBA macro? ( I could run a macro from either Excel or PowerPoint, but would prefer from Excel)
    2) Any way to make a dynamic chart (that automatically grows or shrinks based on data that is inserted/removed) in Excel without using a named range? (I tried using a Table instead of Offset function, but I had the same behavior).


    My real goal is to have a presentation template automatically updated with data from an Excel template. For example, a user opens the Excel template, pastes in or updates their data, which may be a different size from the template, and then the PowerPoint Template automatically updates with the formatted data.

    I included sample files of both Excel and PowerPoint.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    10-31-2013
    Location
    Omaha, NE
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Dynamic chart in Excel doesn't update in PowerPoint after close/reopen, even with Refr

    It seems that Excel is stripping out the name of the file from the data source, which makes the named ranges not work. I couldn't find a work-around for that problem, so I am instead making a macro that a user can run that automatically copies each chart into PPT after their data has been entered.

+ 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. My Excel SQL connection won't refresh after I close and reopen file
    By Cristian888 in forum Access Tables & Databases
    Replies: 7
    Last Post: 03-29-2017, 08:43 AM
  2. Replies: 0
    Last Post: 08-23-2016, 09:43 AM
  3. Replies: 1
    Last Post: 06-09-2016, 12:05 PM
  4. Excel 2007 VBA code to close powerpoint slide show, but not powerpoint application
    By christopher@groth.cc in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-18-2015, 06:39 AM
  5. Close/Reopen Excel using Taskkill - possible?
    By lordterrin in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-17-2014, 04:36 PM
  6. Update linked Excel chart in PowerPoint Presentation
    By Apple Ling in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-22-2012, 03:20 AM
  7. [SOLVED] create chart /table excel-save, close & reopen colors change? Why
    By Anne in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-04-2006, 04:20 PM

Tags for this Thread

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