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
sonyephilAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.