Referencing Worksheets
Adding an Include Region
1. In a worksheet, place the pointer where you want to insert a referenced worksheet.
2. Press Ctrl+Shift+W. A new region appears with an Include button on the left.
Alternatively, on the Input/Output tab, in the PTC Mathcad Worksheets group, click Include Worksheet.
3. Click the Include button. The Open dialog box opens.
4. Navigate to the file you want to reference and click Open. The worksheet displays the full path to the referenced worksheet. Alternatively, you can type or paste the path to the worksheet.
By default the include region displays the absolute path to the referenced worksheet. You can edit the path and make it relative.
Variable and function definitions from the referenced worksheet now apply in the open worksheet, as if they are included in it.
Refreshing Data in the Include Region
When the data in the include worksheet is changed PTC Mathcad Prime does not automatically recalculate the parent worksheet. To load the latest data and recalculate the related regions without recalculating the whole worksheet, do the following:
• In AUTO calculation mode: Click the Refresh button 
in the include region.
in the include region.• In MANUAL calculation mode:
◦ Click the Refresh button in the include region.
in the include region.◦ On the Calculation tab, in the Controls group, click Calculate Now.
|
|
The scripts of advanced controls within the included worksheet (child worksheet) do not run when you recalculate the parent worksheet. To update the advanced controls, you must open the included worksheet directly. The advanced controls recalculate according to your settings on running advanced controls scripts.
|
Additional Information
• You can select and drag the reference box vertically within the worksheet.
• To open the included worksheet, hover over the file path, hold down CTRL and click.
• PTC Mathcad Prime evaluates math expressions in a top-down, left-right order. The definitions in the reference worksheet do not apply to expressions above the include region. You can overwrite a definition from the referenced worksheet by inserting a variable with an identical name below the include region.
• You can include a worksheet inside a solve block to define guess values. However, in the referenced document, the guess values must be declared outside a solve block. PTC Mathcad Prime ignores solve blocks in a referenced worksheet since these are local definitions.
• If the calculation settings in the referenced worksheet are different than those in the parent worksheet, a warning message appears below the include region. PTC Mathcad Prime uses the parent worksheet’s settings.