Compile error due to disabled items

From ODBClink wiki
Jump to navigation Jump to search

Overview

Start-Up compile error

On some machines, some components of ODBClink get disabled by Microsoft Excel. This is typically caused by some third-party addins interfering with the proper execution of ODBClink. In general, this causes compile errors when ODBClinkstarts.

To resolve these compile errors, you must re-enable the addins.

We recommend you first add a trusted location in Microsoft Excel before re-enabling any addins.


How to re-enable disabled items in Microsoft Excel 2010 or 2013

Disabled Items screen in Microsoft Excel 2013

To re-enable disabled items in Microsoft Excel 2010 or 2013, please follow these steps.

  1. Start Microsoft Excel;
  2. Click on the File button;
  3. Click on the Options entry in the menu;
  4. Click on the Addins entry in the list on the Excel Options dialogue;
  5. Using the Manage dropdown, choose Disabled Items;
  6. Click on the Go... button;
  7. For each addin beginning with AddonsLink..., select it and click Enable;
  8. Click on the Close button of the Disabled Items dialogue;
  9. Click on the OK button of the Excel Options dialogue;
  10. Close Microsoft Excel;

You should now be in a position to start ODBClink.


How to re-enable disabled items in Microsoft Excel 2007

Disabled Items screen in Microsoft Excel 2007

To re-enable disabled items in Microsoft Excel 2007, please follow these steps.

  1. Start Microsoft Excel;
  2. Click on the Round Office button;
  3. Click on the Excel Options button;
  4. Click on the Addins entry in the list on the Excel Options dialogue;
  5. Using the Manage dropdown, choose Disabled Items;
  6. Click on the Go... button;
  7. For each addin beginning with AddonsLink..., select it and click Enable;
  8. Click on the Close button of the Disabled Items dialogue;
  9. Click on the OK button of the Excel Options dialogue;
  10. Close Microsoft Excel;

You should now be in a position to start ODBClink.


Related Topics