Suppose you have a sales spreadsheet with monthly sales figures. You want to include the highest monthly figure and the total sales for the year in a Write document. The spreadsheet is called sales97 and the figures you will need run from C1 to C12. The figures need to appear in the middle of a paragraph like this:
"The average monthly sales for 1997 was $xxxx.xx with the highest single month topping out at $xxxx.xx."
Follow these steps to link from the Write document and extract these figures:
In the Write document, type the text of the paragraph. Leave a space where the fields need to be inserted.
Position the cursor between the words "was" and "with".
Select Field from the Insert menu.
Click the Next button (if you want you can enter a more meaningful field name on the first page of the wizard).
Enter the following formula:
=AVG(SSGET("sales97", "C1..C12"))
Click Finish.
Position the cursor at the end of the paragraph and repeat steps 3 through 6, using the following formula:
=MAX(SSGET("sales97", "C1..C12))
Note that the example assumes that the two documents are in the same folder. If they are not, use the full document path of the source document. For example,
=MAX(SSGET("c:\my documents\sales97", "C1..C12"))