+ Reply to Thread
Results 1 to 3 of 3

Power Point VBA Excel Chart Refresh

  1. #1
    Forum Contributor
    Join Date
    05-31-2013
    Location
    Philadelphia, Pa
    MS-Off Ver
    Excel 2010
    Posts
    164

    Power Point VBA Excel Chart Refresh

    Hell All!

    I have an excel report that is a combination of charts, graphs, slicers, and tables. I am now trying to create a simpler version in powerpoint for presentation. I copied and link-pasted several graphs into PP directly from the excel file. If I change the data in Excel then click the refresh button in PP the data updates. The problem is that I need to click that refresh button for each graph that I paste. I'm trying to write a rather simple code in vba that will target the charts/graphs specifically and refresh them. Something like...

    Please Login or Register  to view this content.
    Obviously, this code isn't working. Anyone have any ideas?

    Thanks

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Power Point VBA Excel Chart Refresh

    Why VBA, what if you just show the graph but linked to Excel? They will then refresh automatically.
    I used do do that with Word reports that included graphs.
    I think there is an option refresh all or so
    Last edited by Keebellah; 02-26-2016 at 05:22 PM. Reason: xtra info
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Forum Contributor
    Join Date
    05-31-2013
    Location
    Philadelphia, Pa
    MS-Off Ver
    Excel 2010
    Posts
    164

    Re: Power Point VBA Excel Chart Refresh

    Sorry, I should have mentioned that. I know that I can do that, and currently that's what I'm doing, but the issue is that I can't reformat the graphs, other than size. While that doesn't break the bank, it'd be nice if I could.

    Thanks.

+ 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. Interactive Chart in Power Point
    By harshalcr9 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-18-2015, 06:50 AM
  2. Remove Error when copy Excel pie chart to power point
    By Faridwahidi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-07-2015, 05:01 AM
  3. Can't update/refresh Embedded Excel file within Power Point
    By Mt1013 in forum PowerPoint Formatting & General
    Replies: 1
    Last Post: 06-17-2015, 12:06 AM
  4. 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
  5. refresh excel charts in power point
    By just_some_guy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-01-2012, 10:42 AM
  6. Power Point Chart linked to Excel Chart
    By pr4t3ek in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 09-24-2009, 11:33 AM
  7. how to turn of a series in data sheet of a power point chart using macro
    By chepyalarr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2006, 03:10 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