+ Reply to Thread
Results 1 to 9 of 9

PowerPoint live update excel data during slide show

  1. #1
    Registered User
    Join Date
    04-06-2014
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    5

    PowerPoint live update excel data during slide show

    PowerPoint live update excel data during slide show


    So I have an excel sheet that updates every 30 minutes and been trying to link the sheet to PowerPoint to update during live slide show. I've copy and special pasted as link and set to auto update but only works in edit mode or when the ppt is restarted but never live.

    I've searched numerous threads and nothings worked. Downloaded and installed the add in to update links live :http://skp.mvps.org/updtlinks.html which doesn't work.

    Thought this would work best: How to update excel embedded charts in powerpoint?

    And still no data updates during live slide show. I dont know why either.

    Using office2010. Any help would be much appreciated.

  2. #2
    Registered User
    Join Date
    09-16-2016
    Location
    Ohio, USA
    MS-Off Ver
    2010
    Posts
    43

    Re: PowerPoint live update excel data during slide show

    Im litterly looking for the same thing!

  3. #3
    Registered User
    Join Date
    09-16-2016
    Location
    Ohio, USA
    MS-Off Ver
    2010
    Posts
    43

    Re: PowerPoint live update excel data during slide show

    So I found a way to do it but it cost money.

    check this company out

    http://www.presentationpoint.com/software/datapoint/

  4. #4
    Forum Contributor sorensjp's Avatar
    Join Date
    12-23-2015
    Location
    Yokosuka, JP
    MS-Off Ver
    2007 and 2016
    Posts
    188

    Re: PowerPoint live update excel data during slide show

    Tyger0951,

    I'm using 2016 so not sure if this will work for you. After opening both PowerPoint and Excel I copied an area of dynamic data. Then Paste Special in PowerPoint (I used it from the Home Ribbon Tab Paste drop down). I updated the data in Excel and it worked for me. I'm not sure how this this process will work in Microsoft Office 2010.

    Hope it helps.

    Jim
    Attached Files Attached Files

  5. #5
    Forum Contributor sorensjp's Avatar
    Join Date
    12-23-2015
    Location
    Yokosuka, JP
    MS-Off Ver
    2007 and 2016
    Posts
    188

    Re: PowerPoint live update excel data during slide show

    Tyger0951,

    Sorry I forgot to add a screen shot for you. Under Paste Special click the Paste Link radio button and then select Microsoft Excel Worksheet Object.

    Jim
    Attached Files Attached Files

  6. #6
    Forum Contributor sorensjp's Avatar
    Join Date
    12-23-2015
    Location
    Yokosuka, JP
    MS-Off Ver
    2007 and 2016
    Posts
    188

    Re: PowerPoint live update excel data during slide show

    Tyger0951,

    Sorry I didn't clarify what to do with the Paste Special...

    Under Paste Special click the Paste Link radio button and then select Microsoft Excel Worksheet Object.

    Jim

  7. #7
    Valued Forum Contributor meabrams's Avatar
    Join Date
    10-03-2014
    Location
    USA
    MS-Off Ver
    2007, 2010, 2013, 2016
    Posts
    451

    Re: PowerPoint live update excel data during slide show

    The special paste will allow the update to happen as long as the excel file is left up in the background of the same computer the PowerPoint is running on. There is a way to launch the PowerPoint from the excel file and force the links to re-establish if the file ends up getting closed but I do believe that the show has to be re-launched in order to force this to work.

    Here is what I use on a few of my different PowerPoints updated by Excel

    In Excel

    Please Login or Register  to view this content.
    Bramz

  8. #8
    Registered User
    Join Date
    10-15-2019
    Location
    Nashville, USA
    MS-Off Ver
    Office Professional Plus 2010
    Posts
    1

    Re: PowerPoint live update excel data during slide show

    Hate to ask this, but where to I paste the above code?

  9. #9
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,451

    Re: PowerPoint live update excel data during slide show

    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
    Be very, very careful using IFERROR ! It hides ALL errors which is not always what you want to get correct results

+ 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. two excel charts per powerpoint slide
    By stubyh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-09-2013, 11:09 AM
  2. Slide show with update of data once a day
    By Chil24 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-28-2010, 01:18 PM
  3. Adding a Powerpoint slide using Excel vba
    By db1966 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-25-2008, 12:07 PM
  4. [SOLVED] VBA: Excel sheet to Powerpoint slide
    By Herve in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-08-2005, 12:10 PM
  5. [SOLVED] pasting excel data in a powerpoint slide
    By James in forum Excel General
    Replies: 4
    Last Post: 01-28-2005, 11:06 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1