Frequently Asked Questions

Excel Data Mining Extensions plug-in stopped working; how to I re-enable it?

If you had Excel 2007 Data Mining Extensions for SQL Server 2008 working already (on which see this page), and you suddenly find all the Data Mining Extension menus missing and the plug-in apparently disabled, first check to be sure you started up the right copy of Excel.  Some users may have a special desktop shortcut they use to run Excel as another user.  If you are one of those users, make sure you use the desktop shortcut.

If doing that doesn't make Data Mining Extensions work, then you need to re-enable the extensions manually.

To do this, you must:

  1. Start Excel (if you have a special shortcut on your desktop, use that)
  2. Click on the orb in the upper left-hand corner
  3. Click on the Excel Options rectangle at the bottom of the pop-up window that appears
  4. Click the Add-Ins item in the left-hand sidebar
  5. Make sure the list box at the bottom of the window that appears says Excel Add-Ins, then click Go
  6. Make sure the two Data Mining Extension items' boxes are checked
  7. Click OK
  8. Go through steps 2-5 above, only this time change Excel Add-Ins to Com Add-Ins
  9. Make sure both SQL Server items' boxes are checked
  10. Click OK
  11. Just to be safe, quit and re-start Excel
  12. If a Data Mining item appears in the "ribbon" at the top of the Excel window, you're in business
  13. If not, call ITS Rapid Response (5999) and tell them you have a problem with Excel Data Mining Extensions
  • Richard GOerwitz, 16 July 2009
  • Keywords: data mining, Excel, extensions, plug-in

Other FAQs