SiExcel 2601 and above: Updating a custom SiExcelExpert-linked spreadsheet

(from legacy SiExcel v21.04 and below and legacy SiExcel x64 v24.01 and below)

The Field Solver functions for the Si8000m/Si9000e controlled impedance structures are built into the Microsoft Excel workbook SiExcelExpert.xlsm as user-defined functions. This allows rapid and convenient analysis of board trace characteristics such as impedance, propagation delay, inductance and capacitance against several varying board parameters.

To update a custom Excel worksheet that uses a version of SiExcel prior to v26.01.01 and contains links for the structures to the SiExcelExpert spreadsheet, follow the steps below:

• Open the custom spreadsheet without first opening the SiExcelExpert spreadsheet
• If the following alert is displayed, select Don’t Update

• From the Data menu select Edit links (some versions of Excel may refer to Workbook Links.)

• From the Edit Links dialog, choose Change Source...

• Navigate to the SiExcelExpert.xlsm workbook.(located by default in the C:\Program Files\Polar\SiExcelx64 folder)

• If the alert below is displayed, click OK

• Save the custom workbook

• Open SiExcelExpert.xlsm
• Open the custom workbook and confirm that the calculated cells are updated
• Note: If the workbook options (File|Formulas|Calculation options|Workbook Calculation) are set to Manual Calculation,
  press Shift+F9 to calculate just the active worksheet or F9 (Calculate Now) to calculate the entire workbook.