+ Reply to Thread
Results 1 to 3 of 3

How to auto update the PowerPoint table when new data entered into Excel table?

  1. #1
    Forum Contributor
    Join Date
    12-14-2012
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    104

    How to auto update the PowerPoint table when new data entered into Excel table?

    Hi Excel Forum,

    I have created a table in Excel 2010 (pls see attached table named post.xlsx).

    Then copied the above table into PowerPoint 2010, using “paste link” (I tried to attach the PowerPoint file but the system says "invalid file type" and I cannot attach it).


    Question:
    I have received income data for another month – the new month is 13 and the corresponding new income is 100.
    I typed 13 and 100 into the Excel table post.xlsx and thus extended the table by another column.

    Then I went back to PowerPoint slide, then right clicked on the table there, then clicked “update link”

    Specific Question:
    The newly-typed column in Excel table is not get updated in PowerPoint table.

    Could you please let me know how to do it?
    Thanks

    Mirisage
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    05-09-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2013
    Posts
    259

    Re: How to auto update the PowerPoint table when new data entered into Excel table?

    Hi, you should do the following to have an Excel sheet update. In Powerpoint click INSERT>OBJECT, select file, Click link. Then the sheet gets embedded in yo Powerpoint. To update right click then update.

  3. #3
    Forum Contributor
    Join Date
    12-14-2012
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    104

    Re: How to auto update the PowerPoint table when new data entered into Excel table?

    Hi Hurricanefly,

    Thank you very much.

    I will see if your approach resolves the problem that I have in my hands.

    Thanks gain!
    Mirisage

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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