Excel 2010 - Data Analysis installed but no window appearing

[bobbieweeks]

Morning All

I'm asking this in behalf of a user. We are running Office 2010 part of Office Professional Plus 1010 (corporate install). We have added both the Analysis Toolpak and Analysis Toolpak - VBA to the add-Ins and have the button on the toolbar, however when we click on the button, we don't get the popup window allowing the user to pick the analysis tool they want to use. Have tried this on a number of PCs (we all run the same version) and it doesn't work on any of them.

Does anyone know what we have to do do make this toolpak work?

Thanks

[MarvinP]

Hi bobbie and welcome to the forum.

So you did all the instructions on this link?
http://office.microsoft.com/en-us/ex...010021569.aspx

Then, which function are your trying to do on your data? Are you sure it isn't included in the normal function list?

[bobbieweeks]

Morning, thanks for fast reply. Yes, as stated, I have installed both packs as per what was written in the link. The button is on the toolbar, but when the user clicks on the button there is no window that appears with the list of data analysis tools to pick from that appears. Can you please advise how we get that window to appear with the list of tools to pick from. I don't know what tool they are trying to run, all I know is they asked for the data analysis toolbar to be fixed so that it works so they can access it. Thanks.

[MarvinP]

It seems to me they installed a reduced version of Office or perhaps the Student version. I'd reinstall office and allow the defaults to install.

I hope this fixes the problem.

[bobbieweeks]

Hmmm, it is a corporate version of the software which has been packaged so can be installed via MSI when pushed to PC. We don't install from CDs or anything as we have 10000s of PCs with this package installed (government organisation that is statewide). It doesn't prompt to say the add-in has not been installed or needs to be installed when we add the add-on, like it is mentioned on some pages, so that is why I figured they included it in their packaged version. Are you saying that it appears they have not included it in their packaged version? But wouldn't it then have prompted to install that add-on from CD or somewhere?

Thanks

[martindwilson]

see the last post in this thread
http://answers.microsoft.com/en-us/o...4-51d155744d2b
it maybe the solution
but im not sure the poster has enable and disable confused
see also
http://www.stigviewer.com/check/V-26625

[bobbieweeks]

Thanks for that. I will get the team that manages policy for the department to check as I can't find that policy when I run gpedit.msc.

[bobbieweeks]

Actually, that is for when the "data analysis" button doesn't appear on the data tool bar. It does appear there but does nothing when we click it.

[martindwilson]

you never know with MS weird things happen

[cmarcporto]

It's a long shot, but any chance you figured it out? I'm having the same problem with excel on the laptop my new job gave me and the IT guys have no idea how to fix it.

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

[cmarcporto]

[QUOTE=Pepe Le Mokko;5304026]Administrative Note:

What? I asked the OP if he solved his issue and if so how because I'm having the same problem. How could that possibly be considered hijacking the thread?

[Pepe Le Mokko]

Hi
This thread is 6 years old. If someone had figured it out, it would have been posted.
To get help, might I suggest you start a new thread, eventually referring to this one ? ( add a text link stripped of the www part)
By starting afresh, members might have new ideas and provide valuable help for everyone.
Thank you for helping us help you