Excel does not work well in any application. With the latest release of Solid Edge (V14), it now works as well as it does embedded in another Office app. There are certain rules you need to follow when placing it in Edge and these same rules apply to using it in other Office products as well.
To place it on a draft and have it editable (add rows or columns) later, you must create a excel file on disk. Use the insert object from file command, place it either linked or not. If it is not linked, you can delete the file from disk if not needed.
Both Insert Object New and Copy and Paste will paste the current data or the selected data on the page, but you will not be able to add rows or columns later.