Configuring Excel File Format

To configure Excel file format:

  1. Follow steps 1-3 in the Adding and Editing File Formats section above.
  2. Click .

    The Configure File Format dialog box appears.

  3. Enter a unique name for the Excel file format.
  4. Select the Default checkbox to mark the file format as the default selection. This is will enable quick selection of file formats while adding submissions.
  5. Select Create New to create a new Excel file format from a pre-installed file format. Select the pre-installed Excel file format option from the drop down list.

    The Configure option will be activated.

  6. Click Configure.

    The Configure File Format &endash; Excel dialog box appears.

  7. Check the corresponding checkboxes to Translate cells with formulas, Ignore hidden columns/rows during analysis, and Translate worksheet names.
  8. Click to browse and select the Document Configuration File.
  9. Click OK.

    The new Excel file format appears in the File Formats tab. This file format can be further edited by clicking on .

Parent topic: Adding and Editing File Formats