We are looking for a good way to include portions of an excel file into a draft. Can anyone explain or link me to an article for what's the difference between a normal copy/paste (select some cells & copy in excel - paste in Solid Edge) and the "Insert Object" command in the draft environnement?
It seems with just copy/past that the excel becomes a part of the draft and has no connection anymore with it's original excel file. If double clicking on the inserted excel, it's another kind of editing mode and it does not open the excel as it used to.
Where is the excel saved when just doing a copy/paste, or does it become a part of the draft?
I frequently use Excel for BOMs in draft files. When you want a link between Excel and Solid Edge, use the "paste special" command in Solid Edge and make sure the "paste link" option is selected.
Here is a video. Looks like if you open the Excel file directly and edit, rather than opening it from within Solid Edge Draft you may need to open the Draft file, then Edit/Open the table in Excel and the changes will push into the Draft file from the Excel file.
This question wasn't answered here I don't think:
"Where is the excel saved when just doing a copy/paste, or does it become a part of the draft?"
If you paste it without using special and link or you insert object without linking then it becomes embedded in the draft but it still needs Excel installed to edit it. Same thing with Word documents, etc.
If you do link it then it's dependent on the external file.