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.

What happens if you copy the table in Excel and in PPT - Paste special as Link (Excel worksheet)?

__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials

The table goes in fine as a linked Embedded Object as long as both the Excel spreadsheet and the Powerpoint is open. I have pasted in areas from a number of different worksheets in the Excel file into PPT. When I close down Powerpoint and then open it up again, it asks if I want to update. When I update, the tables get overwritten by the entire worksheet where the table came from. So if I embed A1:E10 as a table in PPT, and then close down and re-open PPT, the Embedded Object suddently becomes A1:Z100 - basically the entire worksheet where the section came from.
Why doesn't the region I paste in stay the same regardless of which files are open or closed?