I am trying to embed Excel tables into a presentation that can be automatically updated. 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 update the table with the external excel data, it overwrites it with the entire spreadsheet, not just the rows/columns I originally embedded.

How to 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.