How do I get the Data Mining ribbon (tab) to show in Excel 2007 or 2010?

Posted on 2010-09-11
Last Modified: 2012-08-14
I've installed the Data Mining add-in but, it doesn't display in Excel 2007 or Excel 2010. I've gone to the Excel options and it's listed in the available application add-ins. Checked the disabled items list and it's not listed there. I do have the .Net Framework 2.0 SP2, .Net Framework 3.0 SP2 and .Net Framework 3.5 SP1 installed on the computer with Excel 2007. I've spent many hours trying to resolve this issue. How do I get the add-in to display?
Question by:Barbara69
  • 4
  • 3
LVL 11

Expert Comment

ID: 33659813
It seems to be a tab that is added by installing the SQL Server Data Mining add-in, so youshould look for that add-in in your add-ins list. If it is missing, it probably needs to be installed n your system.
LVL 11

Expert Comment

ID: 33659816
Hmm, please disregard the previous post.

Try unchecking the add-in, closing and re-opening Excel and checking the add-in again. Does the tab show up?

Author Comment

ID: 33661640
I've tried that and it doesn't work. Also, the computer with Excel 2007 is running XP and the one with Excel 2010 is running Windows 7.
LVL 11

Expert Comment

ID: 33662107
And the addin is checked I presume.
Maybe your toolbar customisation file has become corrupt.

Try to locate a file called excel??.xlb and rename that to Excel??.old Then restart Excel and try checking the add-in again.

Another hunch: you haven't accidentally installed an old version (which would mean it's menu appears in the add-ins tab of the ribbon)?
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline


Author Comment

ID: 33666130
Is it possible for the toolbar customization file to be corrupt on a brand new laptop (last Friday)? Where is the excel??.xlb file for Windows 7? What do you mean by accidentally installed an old version (of what)? I'll have to try your suggestion on my desk top later tonight.

Accepted Solution

Barbara69 earned 0 total points
ID: 33668801
I found the solution. I forgot to install Data Mining Client for Excel and then selecting the second choice under Data Mining Client for Excel.  Thanks for your assistance with this matter.
LVL 11

Expert Comment

ID: 33669381
I meant to say whether you accidentally installed thw rong version of the tool (the add-in). I was close, wasn't I? :-)
Of course it is unlikely the xlb file is corrupt on a new machine. I missed that information.
No need for points as far as I'm concerned.

Expert Comment

ID: 35219881
I have the same problem as well. I downloaded the data mining add-ins but the Data Mining tab doesn't appear on the excel menu. Since I have already installed the rest, its not letting me start again to install the Data Mining Client for excel. Is there somewhere I could get it installed?
Please help

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now