Including One Worksheet Inside Another

You can insert a reference to a worksheet, which makes the current worksheet behave as if you had inserted the actual regions from the referenced worksheet.

To insert a reference to a worksheet:

1. Choose Reference from the Insert menu to display the Insert Reference dialog.

2. Click "Browse" to locate and select a worksheet or type the complete path or Internet address (URL) to a worksheet, such as:

   C:\Program Files\Mathsoft\Mathcad\conform.xmcd
   
   http://www.mathsoft.com/coeffs.xmcd

3. Choose "Use relative path for reference" if you want a relative path. You must save the file containing the reference before setting a relative path.

Upon completing these steps, you see an icon,

with the name of the referenced worksheet showing where the referenced worksheet definitions and functions take effect. Double-click the icon to view the referenced worksheet.

To change the target of a reference, select the reference in your worksheet, open the Properties dialog and access the Reference tab. Change the path and/or name of the referenced file and click OK to update the reference in the worksheet.

To update a worksheet containing a reference:

1. Make the change in the referenced worksheet and save.
2. Return to the referencing worksheet, click on the reference icon, and press [F9] ("Calculate"). Your worksheet then incorporates any changes.

You can also include calculations in a document without showing them by using collapsed areas.