To save the BOM as a file:
- In the Bill of Materials dialog, display the data you want to save.
- Click .
- Click OK to display the Save As dialog.
- Select .xls or .csv from the Save as type drop-down list.
- Click Save.
Note: You can embed the saved .xls file into drawings as an OLE view.
Because the file is saved as an .xls spreadsheet, it can be opened and modified using Microsoft Excel:
- Right-click the Bill of Materials.
- Select Modify.
The Bill of Materials is displayed as an Excel spreadsheet.
- Change the spreadsheet and click on the spreadsheet. The embedded Bill of Materials will be updated.