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:
Choose Reference from the Insert menu to display the Insert Reference dialog.
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.ptc.com/go/mathsoft/coeffs.xmcd
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. The referenced worksheet's definitions and functions take effect at this point, just as if you had copied them into the worksheet. 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:
You can also include calculations in a document without showing them by using collapsed areas.