Related Topics and Links:

Spreadsheet Module

Word Processing Module

Function Wizard- Data Sources

Spreadsheet References

In Synthesis Workbooks, the spreadsheet reference feature provides integration between the spreadsheet and word processing modules in the same workbook. You can insert a reference from any cell, or consecutive range of cells, from the spreadsheet into a desired location in the word processing document. If the referenced cells in the spreadsheet are changed, the word processing module is automatically updated. The changes are visible when you use the Review tab to see a preview or  generate the Word report.

To  insert a spreadsheet reference, place the cursor at the desired location in the word processing document and choose Home > Report > Spreadsheet Reference.

Note that you can also use the Spreadsheet Reference function in the word processing module’s Function Wizard.)

The Select Cells window shows the contents of the spreadsheet module in the current workbook. Select a cell or range of consecutive cells and click OK.

For the example data shown above, the entry would look like this:

 

© 1992-2017. HBM Prenscia Inc. ALL RIGHTS RESERVED.

E-mail Link