Fix Missing Office Connectors Toolbar in Excel - Step-by-Step Guide

How to Fix Missing Office Connector's Toolbar in Excel

Overview

Experiencing issues with the Office Connector's toolbar not appearing in Excel? Follow these methods to resolve the problem. A video guide covering both methods is available: How to Fix Office Connector's Missing Toolbar

Method 1: Disable and Enable Add-ins

  1. Access Add-ins Settings: Open Excel, go to File > Options > Add-ins.
  2. Disable Add-ins: Click the Go button. Uncheck any add-ins starting with "Office Connector". If there are no add-ins listed, proceed to Method 2.
  3. Apply Changes and Restart Excel: Click OK, close all Excel sessions, and then reopen Excel.
  4. Re-enable Add-ins: Navigate again to File > Options > Add-ins and click the Go button. Recheck the previously unchecked "Office Connector" add-ins.
  5. Finalize and Check: Close and reopen Excel. The toolbar should now be visible.
Note: If this method resolves the issue, there is no need to proceed to Method 2.


Method 2: Reinstall Excel Add-ins

  1. Access Add-ins Settings: In Excel, go to File > Options > Add-ins and click the Go button.
  2. Reinstall Specific Add-ins: Perform the following steps:
    1. Browse and run C:\Program Files (x86)\Event 1\Common\Excel 2016 QueryTable Fix. Click Yes to confirm replacement if prompted.
    2. Browse and run C:\Program Files (x86)\Event 1\Office Connector\OfficeConnector. Click Yes to confirm replacement if prompted.
    3. Browse and run C:\Program Files (x86)\Event 1\Office Connector Import\OfficeConnectorImport. Click Yes to confirm replacement if prompted.
  3. Apply Changes and Restart Excel: Click OK and close all Excel sessions.

By following these steps, you should be able to restore the missing Office Connector's toolbar in Excel. For a visual walkthrough, refer to the provided video link above.

    • Related Articles

    • How to Fix Office Connector for Sage 300 CRE License Expiring Error

      Overview A very common error message that Office Connector users might experience is one that states their licenses have expired or are about to expire. Complete the steps below to keep your Office Connector running smoothly and avoid any workflow ...

    • Change Excel from 64-Bit to 32-Bit

      Many of our data tools built for Sage 300 CRE and Sage Intacct require a 32-Bit version of Excel. Most modern Microsoft Office installations default to 64-Bit. Use this article to switch from a 64-Bit to a 32-Bit version of Excel. Check Your ...

    • How to Fix Missing Accounting Link from Left-Hand Menu in Sage Construction Management

      If you need to refresh the accounting link to your accounting product within Sage Construction Management, follow these steps: Verify Browser Functionality: Open Chrome and Incognito Chrome browsers to check for the missing accounting link. Log Out ...

    • Missing Logo on Sage 300 CRE Forms

      In case your would like to add a logo to your forms in Sage 300 CRE (applicable for forms designed in Crystal Reports) or if the existing logo is missing, follow these steps: 1. Locate logo file (bpm of JPG file with your logo) on your network. This ...

    • How to Fix MyAssistant Not Sending Emails

      Overview This article provides solutions to the most common issues that prevent MyAssistant from sending emails. Issue 1: Services Not Running on the Server Symptoms: MyAssistant stops sending emails after Windows updates or server restarts. ...