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:
- Start Excel (if you have a special shortcut on your desktop, use that)
- Click on the orb in the upper left-hand corner
- Click on the Excel Options rectangle at the bottom of the pop-up window that appears
- Click the Add-Ins item in the left-hand sidebar
- Make sure the list box at the bottom of the window that appears says Excel Add-Ins, then click Go
- Make sure the two Data Mining Extension items' boxes are checked
- Click OK
- Go through steps 2-5 above, only this time change Excel Add-Ins to Com Add-Ins
- Make sure both SQL Server items' boxes are checked
- Click OK
- Just to be safe, quit and re-start Excel
- If a Data Mining item appears in the "ribbon" at the top of the Excel window, you're in business
- If not, call ITS Rapid Response (5999) and tell them you have a problem with Excel Data Mining Extensions
- I have access to the data warehouse. What tools do you support?We actually support accessing the data warehouse via Excel and Access. We will happily try to...
- 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...
- How do I request access to the Carleton Data Warehouse?You can request access to the Data Warehouse by calling the Helpdesk (x5999) or by...