Compile error due to disabled items
Overview
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
To re-enable disabled items in Microsoft Excel 2010 or 2013, please follow these steps.
- Start Microsoft Excel;
- Click on the File button;
- Click on the Options entry in the menu;
- Click on the Addins entry in the list on the Excel Options dialogue;
- Using the Manage dropdown, choose Disabled Items;
- Click on the Go... button;
- For each addin beginning with AddonsLink..., select it and click Enable;
- Click on the Close button of the Disabled Items dialogue;
- Click on the OK button of the Excel Options dialogue;
- Close Microsoft Excel;
You should now be in a position to start ODBClink.
How to re-enable disabled items in Microsoft Excel 2007
To re-enable disabled items in Microsoft Excel 2007, please follow these steps.
- Start Microsoft Excel;
- Click on the Round Office button;
- Click on the Excel Options button;
- Click on the Addins entry in the list on the Excel Options dialogue;
- Using the Manage dropdown, choose Disabled Items;
- Click on the Go... button;
- For each addin beginning with AddonsLink..., select it and click Enable;
- Click on the Close button of the Disabled Items dialogue;
- Click on the OK button of the Excel Options dialogue;
- Close Microsoft Excel;
You should now be in a position to start ODBClink.