Excel Export Setup

Problem

Excel must be configured properly to run with HMTS.  Below you will find the steps necessary to setup Excel to work with HMTS.

Microsoft Excel Export Setup (Office 2007)

1. Open Excel, if Excel is not installed on your computer, it will need to be installed.
2. Click on the Office button in the top left-hand corner.
3. Click on the Excel Options button.
4. The Excel Options window will display. In the list on the left, select Trust Center, and then click the Trust Center Settings… button.
5. The Truce Center window will display. In the list on the left, select Macro Settings.
6. In the Macro Settings section select Enable all macros and also place a check mark in the Trust access to the VBA project object model in the Developer Macro Settings section.
7. Click the Ok button in the trust center window.
8. Click the Ok button in the Excel Options window.
9. Close ALL opened Excel sheets.
10. Try exporting the data from the HMTS software. All data should export properly at this point.

Microsoft Excel Export Setup (Office 2003 and earlier)

1. Open Excel, if Excel is not installed on your computer, it will need to be installed.
2. In the Excel menu click on Tools and then Macro and select Security.
3. A window labeled Security will be displayed.  The first tab labeled Security Level will be selected.  Make sure that the security level is set at Medium.  This setting will not leave you vulnerable to security issues that occur with lower settings, but you will be prompted by other macros if you want to open them or not.  Humboldt Scientific does not recommend going below a security level of medium.
4. Next, select the Trusted Publishers tab.  At the bottom of the tab you will notice up to two checkboxes depending on what version of Excel you are using.  Excel version 2000 and lower only have one checkbox.  Whatever version of Excel you have, make sure all available checkboxes have checkmarks next to them.
5. Click the Ok button at the bottom of the security window.
6. Close ALL opened Excel sheets. 
7. Try exporting the data from the HMTS software.  All data should export properly at this point.