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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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.
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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)?

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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

752 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