Use a spreadsheet to edit iAssemblies

Values calculated by equations in the spreadsheet are shown with a mango background in the iAssembly table.

1. On the Quick Access toolbar, click Open and browse to the iAssembly factory file, and then click OK.
2. In the browser, click to expand the table folder.
3. Right-click the table icon and select Edit via Spreadsheet. The table opens in Microsoft Excel.
4. Edit cells as needed, but avoid editing column headers. If you edit column headers, it causes all members to fail without warning.
5. Use Microsoft Excel commands as needed. For example:
   • Copy and paste rows to add new factory members quickly. Change only needed cells to differentiate between members.
   • Use formulas to create the data.
   • Sort the data to organize it in a logical way, such as sorting on a critical value in ascending or descending order.
6. Save the spreadsheet and close it.

Tip: To test the changed values, right-click the table in the browser and select Edit via Table. In the iAssembly Author dialog box, click Verify to check syntax and valid values in cells.