How to embed Excel table in Powerpont that automatically updates?

I am trying to embed Excel tables into a presentation that will automatically update when I change the Excel file. I have been using Paste Special to Embed Object with Link. I paste in the Excel area that I want - so far so good. But when I click Update Link to refresh the table with external excel data, it overwrites the Excel region I pasted in with the entire spreadsheet.

Example: I have about 20 Excel tables on 5 different worksheets in a master file (multiple tables on each sheet). Table 1 is from A1:E10. I copy/paste A1:E10 into Powerpoint and Embed Object with Link. When I close down the file and open up again, and click Refresh Links the Table that was A1:E10 suddenly becomes A1:Z100. Basically the entire worksheet now shows where just one section was embedded before.

How do I define which rows and columns the embedded table should include from my master Excel file? I have tables on multiple worksheets in that file, all of which are embedded into seperate powerpoint slides. I dont want to have to re-embed every time I update?

-------------Problems Reply------------

There is no Embed Object with Link option. What exact steps are you using and what options do you choose?

It should do exactly what you want if you:

- Select the part of the table you want in Excel and copy

- Switch to PPT, choose Paste Special, select Paste Link and make sure to choose "Microsoft Excel Worksheet Object" under "As". Sometimes that option doesn't appear in the list; if not, go back to Excel and try copying again.

Category:Office Views:8 Time:2013-11-23

Related post

  • These updates for Office 2007 - KB2760411 (Office), KB2760588 (Office) and KB2760583 (Excel) - keep appearing on my automatic updates although I've alreadu installed them 2014-07-25

    These 3 updates keep appearing on my automatic updates to be updated, although I've already downloaded and installed them several times - how do I stop them? They are for Office 2007: KB2760411 (Office), KB2760588 (Office) and KB2760583 (Excel) -----

  • How do i update my EXCEL table pasted in Powerpoint automatically? 2013-06-05

    I have created a table in excel and paste special this table onto Powerpoint. But when i update my Excel figures on my spreadsheet, the table in the Powerpoint do not update itself automatically. Please help! --------------Solutions------------- Tech

  • Unable to edit embedded Excel tables in Word 2007 2014-07-30

    I have a user that cannot edit embedded excel tables within Word 2007 Tried opening Excel 1st Tried a HotFix, but nothing Ran a repair on Office --------------Solutions------------- What happens when you try to edit embedded excel tables within word?

  • Embedded Excel tables in Powerpoint documents 2014-08-30

    In my work I embed Excel tables in PowerPoint presentations. We are slowly making the switch from Office 2003 to Office 2010 so we are working with our decks in compatibility mode. Here's what happens: We create a deck. Someone else in the office ope

  • can't embed an excel table into the word document 2015-01-15

    can't embed an excel table into the word document. keep getting error message about not enough ram or anti virus may be blocking it. Tried every thing and still no luck. --------------Solutions------------- Try starting Word in "Safe" mode to see if

  • looking to embed excel into html? 2010-12-03

    I like the power of the pivot tables and was wondering if there is an easy way to embed excel sheets into the html for web? If not, is there something similar on the web? Gordon --------------Solutions------------- There's a jQuery plugin: http://plu

  • Opening an Embedded Excel Table in an Email 2012-02-03

    I embedded an excel table in an outlook email so that the recipient can use it to enter data and forward to a supervisor. I am able to open and edit the spreadsheet before sending the email but, after sending it, it won't open. I would prefer not to

  • Link to excell table on Power Point 2012-08-10

    In need to know how can I PASTE an EXCELL table or graphics in Power Point but as a link to the file, not the file added to the power point. I use to do this in office for PC but I cant find the way in office for mac. Please Help Claudio Navarrete M.

  • Importing an Excel table and sizing to fit slide 2013-07-07

    In 2007: I would like to import an Excel table & I don't want my users to be able to open the table by double clicking on it in PPT. I would also like it to be sized automatically to the slide as I have over 60 of these tables to import. Can you

Copyright (C), All Rights Reserved.

processed in 0.193 (s). 11 q(s)