Microsoft Excel Exports dialog box

When you select the Microsoft Excel option in the Exports dialog box (see Exports dialog box), some extra options are available. To use this option, Microsoft Office 2007 or later must be installed on your computer.

Note You may need to set an access security setting in Microsoft Excel before you can run the export. If this applies to your computer, UNICOM Intelligence Reporter - Survey Tabulation displays a message telling you this. To change the security setting, see Enabling security access for Microsoft Excel, Word, and PowerPoint exports.

You can optionally choose to export data in chart format. The export creates each chart on a separate worksheet immediately following the worksheet that contains the related table. Select a chart type from the list. To use a custom chart that you have created in Excel, type in the name of the custom chart. To specify a chart template (Excel 2007 only), click Browse... to select the desired file. For details of the way in which you can display data in charts, see the "Display results in charts" topic.

Note The chart type you select is used only if you have not specified a chart type for a table using the Table Properties dialog box on the View Tables tab.

The Excel worksheets that contain the tables are called T1, T2, T3, etc. The worksheets that contain charts are called T1_ch, T2_ch, T3_ch, etc. where T1, T2, and T3 are the names of the worksheets containing the tables to which they relate.

Select this option to hide Excel during the export. This makes the export faster.

Select if you want UNICOM Intelligence Reporter - Survey Tabulation to automatically launch Excel and open the file that contains the exported table(s) when the export is complete.

Check this box and enter a name and location for the output file, or choose the Browse button to browse to the folder where you want to save it. If you do not specify a save location, and the Launch after export option is also not selected, you are prompted to either launch the associated application or select a save location.