Summary

The SpreadSheets tab contains makeup records of the SpreadSheets in the SpreadSheet Group.

Important: Only SpreadSheet operators can add, edit or execute SpreadSheets.

Run a SpreadSheet

1. Right-click the SpreadSheet that you want to run to see the options menu.
2. Click Execute SpreadSheet or press Ctrl+X.
3. Complete the Load Data Setup form.
4. Click OK.

   The SpreadSheet loads, and then opens.

Add a SpreadSheet

To add a SpreadSheet to a SpreadSheet Group:

1. Switch to Edit mode.
2. Press Insert.
3. Complete the fields on the SpreadSheet Group SpreadSheets - Details tab.

Edit a SpreadSheet

1. Right-click the SpreadSheet that you want to edit.
2. Click Edit SpreadSheet Design from the menu.
3. When the Information box appears, click OK.
4. Use your knowledge of Microsoft Excel to edit the SpreadSheet Template.
5. In the main menu, click File | Save Design, and then exit the SpreadSheet.
6. Check your changes by right-clicking the SpreadSheet and selecting Execute SpreadSheet.
7. Complete the Data Setup window, and then click OK.
8. Check your changes in the SpreadSheet.