MTS TestSuite Report Add-in tab missing in Excel.

PROBLEM

 

 

MTS TestSuite Report Add-in tab missing in Excel.

 

ANSWER

 

Troubleshooting Guide

MTS TestSuite Report Excel Add-in

 

 

Add-in not displayed

 

 

If the MTS TestSuite Report Add-in is not available as a Microsoft Excel Add-in tab verify the following.

 

  • Check to see a Reporter license exists on the workstation. This can be verified through the License Administrator tool (Start à All Programs à MTS TestSuite)

 

 

 

 

 

 

  • If Excel was installed (upgraded) after TestSuite was installed then you must re-activate the license to get the Add-in to show up. If the computer has internet access open the MTS TestSuite License Administrator tool, select the license key and click Reactivate… 

 

NOTE: Optionally TestSuite can be re-installed following an Excel installation to get the Add-in to show up.

 

  

 

  • Verify the MTS TestSuite Add-in is not in the list of disabled Add-ins. This can be checked by selecting Excel Options à Add-Ins à Manage à Disabled Items and click Go…

 

If the MTS TestSuite Add-in is listed as disabled select and click ‘Enable’.

 

 

  • Verify the MTS TestSuite Add-in is enabled as a COM Add-in. This can be checked by selecting Excel Options à Add-Ins à Manage à COM Add-ins and click Go…

 

If needed check the MTS TestSuite Add-in checkbox and click OK.

NOTE: If the MTS TestSuite Add-in continually fails to load as a COM Add-in take note of any message displayed in the ‘Load Behavior’ and pass it along to MTS support.

 

 

  • Verify the Trust Center settings will allow the MTS TestSuite Add-in to be enabled. Review the Trust Center setting and verify both the ‘Require Application Add-ins to be signed by Trusted Publisher’ and ‘Disable all Application Add-ins (may impair functionality)’ checkboxes are unchecked. Verify this at: Excel Options à Trust Center à Trust Center Settings à Add-ins

 

  • Sometimes the Windows User Account Control (UAC) can interfere with the MTS Reporter Add-in. It is recommended that UAC is turned off. Once this setting is changed restart Windows and re-install TestSuite. This setting can be found in the Control Panel à System and Security à Action Center.

 

 

 

  • Reinitializing the MTS TestSuite COM Add-in may reload a missing Add-in. This can be done through the Excel Options à Add-Ins à Manage à COM Add-ins dialog.

 

    • Uncheck the MTS TestSuite Add-in
    • Click OK to close the dialog
    • Re-open the COM Add-ins and check the MTS TestSuite Add-in

 

 

  • Reactivating the license key may reload the Add-in. If the computer has internet access open the MTS TestSuite License Administrator tool, select the license key and click Reactivate… 

The License Administrator tool can be found at (Start à All Programs à MTS TestSuite)

 

 

 

 

  • If problems persist contact MTS support and forward along a detailed desciption of the problem along with the C:\MTS TestSuite\GlobalLog\FaultError.log.

 

 

Other MTS TestSuite Report Add-in failures

 

 

  • The MTS Report Add-in does not support the Starter version of Excel. 

 

    • Users may get the error message “Unable to load Excel to edit the report template. Verify that a supported version of Excel is installed correctly.”

 

    • If the Starter version exists on the workstation it needs to be uninstalled.

 

 

 

  • The MTS Report Add-in does not support the “Click-to-Run” version of Excel.

 

    • Users may get the error message “Unable to load Excel to edit the report template. Verify that a supported version of Excel is installed correctly.”

 

    • To determine whether you have Microsoft Office Click-to-Run installed on your computer, click the File tab and then click Help. If you see a Click-to-Run Product Updates section, then Click-to-Run is installed on your computer.

 

    • Microsoft provides instructions to switch to using an MSI-based Office edition here:

 

http://office.microsoft.com/en-us/excel-help/click-to-run-switch-%20to-using-an-msi-based-office-edition-HA101850538.aspx

 

  • Prior install of Office Compatibility Pack (Office 2003). This is a Microsoft issue where if the user had previously used Excel 2003 and installed the office compatibility pack to be able to read the 2007 format files, and then later upgraded to 2007 or 2010, the file associations can be a bit messed up.
  1. Users may get the error message “Unable to load Excel to edit the report template. Verify that a supported version of Excel is installed correctly.”
  2. The user will need to manually clean up the issue in this case, based on this MS knowledge base article (http://support.microsoft.com/kb/2650096).

 

 

  • Under certain conditions the report template may not automatically link to the test (all the clickable items are grayed out). To link the report template to test run data, click on the Test icon on the MTS TestSuite Report ribbon, and select the desired test.

 

 

This issue may be a result of the Windows User Account Control (UAC) or if the user does not have administrative privileges. Turning off UAC and/or starting TestSuite by using “Run As Administrator” may resolve this. NOTE: Windows needs to be restarted after tuning  off UAC.

 

K
Keary is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.