Knowledge Base
Zebra BI for Excel

Zebra BI for Office Troubleshooting Excel

In this article, you can review the most common problems users encounter when trying to use Zebra BI for Office. Most of them are connected with IT restrictions and permissions set in Excel or PowerPoint.

In this section:

  • Office add-in store not available
  • The optional connected experience setting
  • Trust center setting

Office add-in store not available

Sometimes it happens that the Office add-in store is unavailable due to IT restrictions. Read below how you can react in such a situation.

If you are unable to access the Office Store and see this message:

it means that you don’t have permission from your IT to access the Office store for security reasons.

To solve this, you should contact your IT administrator and ask them to use the centralized deployment of Office add-ins to deploy Zebra BI add-ins for single users, groups, or the whole organization by following the instructions on Microsoft’s website.

This approach is preferable for large organizations because it enables the administrators to have control of the add-ins used in the company and what permissions those add-ins have to prevent any security issues.

For additional information you can also refer your IT department to these articles:

NOTE:

Centralized Deployment is only supported for online mailboxes. It does not support deployment to on-premises Exchange mailboxes. As such, Centralized Deployment (and Integrated Apps) requires an Exchange Online Mailbox, which is why your users who are On-Premises can’t see the add-ins.

The Optional connected experiences setting

Users can also face problems when adding the Zebra BI for Office because some privacy settings are configured that way. When this is the case, an error message saying: »Admin disabled service needed to use this function« or »The service required to use this feature is turned off. Check your privacy settings.« appears on the screen.

The Zebra BI for Office is web-based which means that users need to enable the connection under Optional connected experiences.

To access this setting, you need to open Excel Options:

  • Step 1: Click on File > Options
  • Step 2: Under General click on Privacy Settings
  • Step 3: Under privacy settings, mark the checkbox next to ‘Turn on optional connected experiences’. Click OK 2x.

You can also find more information in Microsoft’s article about the optional connected experiences in Office.

Trust center settings

Sometimes the add-in is unable to start because of the settings in the Trust center. There can be two possible issues.

Get Add-ins is disabled

If this checkbox is marked in your Trust center, you will not be able to open the AppSource store and the option to click on Get Add-ins or My add-ins will be grayed out.

The steps to resolve this problem are described below:

  • Step 1: Click on File > Options
  • Step 2: Click on Trust Center and choose Trust Center Settings
  • Step 3: Click on Trusted Add-in Catalogs on the left and uncheck 2 checkboxes: ‘Don’t allow any web add-ins to start‘. To be able to get Zebra BI for Office, you also need to untick the second checkbox ‘Don’t allow web add-ins from the Office Store to start‘ because the add-in is web-based.
  • Step 4: Click OK.

Get add-ins is enabled but no add-ins available

In case you click on the Get Add-ins, search for Zebra BI, and receive a message saying »Add-in failed to start« or »No add-ins currently available«

you should also head over to the Trust center and check the settings.

  • Step 1: Click on File > Options
  • Step 2: Click on Trust Center and choose Trust Center Settings
  • Step 3: Click on Trusted Add-in Catalogs on the left and uncheck the 2nd checkbox: ‘Don’t allow web add-ins from the Office Store to start‘.
  • Step 4: Click OK.

Finally, if you experience any additional issues when installing our add-ins, please contact us at support@zebrabi.com.

Was this article helpful?

Previous Article

Initial Setup Guide: Excel

Next Article

Helpful resources