• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1700
  • Last Modified:

Table Analysis tool missing in Excel

After I installed the data mining client for excel, i formatted my data as a table. After that, i notice my Table tools on the ribbon had just the Design option. the Analyze option is missing. I also checked the sample data. Its not there either. Is there anyone that has an idea of how i can get it back. Please help me, its very urgent.
Thanks
0
sonyephil
Asked:
sonyephil
  • 6
  • 5
1 Solution
 
vmaganCommented:
what version of office are you running? this is an add-in that can be added if it was in initially installed on the computer.

lets start with what version of office is this?
0
 
vmaganCommented:
0
 
sonyephilAuthor Commented:
Hi, I'm using microsoft office 2007 version
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
sonyephilAuthor Commented:
Oh no that did not help. that only activated the analysis tab on data ribbon. What i'm trying to get back is the ANALYZE ribbon where you can predict, forecast, etc. I already have the add-ins installed. DO you have any ideas?
0
 
vmaganCommented:
Try doing a repair off of the 2007 cd. or put in the cd and try to browse to the specific file. not exactly sure what is the file name. i will check my version and see what i have at home to see if i can walk you through it, but a repair gives you the option to select or remove more features/addins. You can browse to the location by putting in the cd and following steps below.

click on the Office Button - Click on Excel Options -Click on Add-Ins Click Browse -
Navigate to the CD and search for the files which should be somewhere under the excel folder within the cd

ill see if i can give you more specifics as to where the file is located when i get home, but the repair should do the job. Let me know when you try this if it works or not.

Thanks,

Vic

0
 
sonyephilAuthor Commented:
I tried that several times but that did not work either. I'm really struggling with it. Do you have any other ideas please? Have you checked your version on your own system?
0
 
vmaganCommented:
im checking it right now, can you post a screen shot of your excel toolbar? where the ribbon should be?
0
 
sonyephilAuthor Commented:
Hello! I just attached a picture of my ribbon. Under the table tools (After data mining ribbon) there should be an analyze ribbon (where i can forecast and predict) and the design ribbon. I had it and practiced with it on the sample data. After I created my own data and formatted it as a table, it just went off. I have tried checking the add-ins options, i have tried modifying the installation but unfortunately, nothing has worked
missing.jpg
0
 
vmaganCommented:
Check add/remove programs and check to see if you have sql server 2005_dmAddin or something similar to that installed on your pc. If you do then select it and click on modify. Select the first option "Table Analysis Tools for Excel". This will give you 3 more options, select the 2nd option, which is "this feature and all sub features will be installed on this hard drive". Once this has been installed go ahead and open up a table, the Analyze option should be available now.

ok, this is what I found. Download this data mining add-ins for Excel.

http://www.microsoft.com/downloads/en/details.aspx?FamilyId=7c76e8df-8674-4c3b-a99b-55b17f3c4c51&DisplayLang=en

when you get prompted for the install you will see four options, which i have attached. Select the first option "Table Analysis Tools for Excel" and click the drop down arrow to the left. This will give you 3 more options, select the 2nd option, which is "this feature and all sub features will be installed on this hard drive". Once this has been installed go ahead and open up a table, the Analyze option should be available now.

I installed this and it worked for me, see my images below.

 Table Analysis tooks for Excel install  Analyze Ribbon after install
I hope this works for you!

Vic
0
 
sonyephilAuthor Commented:
Thanks a lot!!! It worked finally. I'm so grateful for your help
0
 
vmaganCommented:
I'm glad it worked for you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now