Knowledge base KB0187

Security settings may prevent think-cell from being loaded

Problem

If you cannot find think-cell in PowerPoint or Excel, security settings in PowerPoint or Excel may prevent think-cell from being loaded.

Note: Other possible causes for think-cell not starting are described in KB0004.

Symptoms

When starting…

  • PowerPoint [Excel] 2007, and creating a new blank presentation ( CTRL + N ): The yellow Office message bar appears below the PowerPoint [Excel] ribbon: Security Warning: Application Add-Ins have been disabled.

  • PowerPoint [Excel] 2010 and later: The yellow Office message bar appears below the PowerPoint [Excel] ribbon: Security Warning: Application Add-Ins have been disabled.

In case no Office message bar appears when starting PowerPoint [Excel] 2007 and later, yet think-cell is not available in the Insert tab of PowerPoint [Excel], please refer to section Detailed Analysis, further down, for additional information.

Solution

To manually allow think-cell's certificate, follow the steps below. Please note, that as a system administrator you can also distribute the think-cell certificate.

PowerPoint [Excel] 2007:

  1. Restart PowerPoint [Excel] and create a new blank presentation ( CTRL + N ) to bring up the Security Options dialog:

  2. Click the Options… button in the message bar. In the Security Options dialog find the Add-In think-cell. Select Enable all code published by this publisher. and confirm with OK.

    Office 2007 Security Alert

PowerPoint [Excel] 2010 and later:

  1. Restart PowerPoint [Excel]: The yellow Office message bar appears below the PowerPoint [Excel] ribbon: Security Warning: Application Add-Ins have been disabled.

  2. In the ribbon, click on FileInfoEnable ContentAdvanced Options.

    Office 2013 Security Advanced Options

  3. In the Security Options dialog find the think-cell add-in. Select Enable all code published by this publisher. and confirm with OK.

    Office 2013 Security Alert

Detailed Analysis

For a detailed analysis in PowerPoint [Excel] 2007 and later, refer to the steps below:

  1. Open the Trust Center Settings… dialog:

    • PowerPoint [Excel] 2007: Click on the Office Button Office Button in the upper left corner → PowerPoint [Excel] OptionsTrust CenterTrust Center Settings…

    • PowerPoint [Excel] 2010 and later: Click on FileOptionsTrust CenterTrust Center Settings….

  2. For testing only, temporarily deselect all options in section Add-Ins and then restart PowerPoint [Excel]. Is think-cell working now? (Note: For security reasons, do not keep these settings after completing testing).

  3. If think-cell is working now, we recommend that you choose the following options:
    Add-Ins: Require Application Add-Ins to be signed by Trusted Publisher.
    This requires that think-cell is added to the list of Trusted Publishers.

    Office 2013 Trust Center Add-In Settings

  4. This list can be found in Trust Center Settings …Trusted Publishers. If think-cell is not yet listed, use the following steps to add it.

    1. Go to Trust Center Settings …Add-Ins Settings and make sure that the option Require Application Add-Ins to be signed by Trusted Publisher is ticked.

    2. Go to Trust Center Settings …Message Bar and make sure that the option Show the Message Bar in all applications when active content, such as ActiveX controls and macros, has been blocked. is ticked.

    3. Please proceed as described in section Solution, above.