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?