How To Add an Excel Workbook Report to a remiCrystal Task

To add a Microsoft Excel Workbook report to remiCrystal:

1. Open an existing remiCrystal task or create a new one 
2. Go to the Reports & Actions tab
3. Click on the Excel Workbook button and select the Excel file you would like to use
4. In the Excel Workbook configuration window, you can configure the following
   1. Workbook Path: the path to the selected workbook
   2. Workbook Name: the name of the workbook in remiCrystal
   3. Password: the password for the Excel Workbook if one is required
   4. Description:  the optional description of the workbook
   5. Use original workbook instead of a cached copy: if checked remiCrystal will not make a working copy of the workbook and will instead use the original file
   6. Save Original As Excel 97-2003: once remiCrystal completes processing the workbook, it will save the file as an Excel 97-2003 (.xls) file.
   7. Save Original as Excel 2007: once remiCrystal completes processing the workbook, it will save the file as Excel 2007 (.xlsx) file.
   8. Enabled: check to specify if this report should run as part of the remiCrystal task
   9. Vital: when checked, the entire remiCrystal task will be stopped if this report fails to run for any reason
5. Under the Macros tab, you can select which Macros should be run by remiCrystal once it opens the Workbook 
6. You can also specify values for individual cells to be set by remiCrystal under the Cell Values tab
7. Finally, you can specify if you would like to save a single worksheet or entire worksheet to a different format under the Output format tab 
8. Hit the Save button to complete setting up the Excel Workbook