installed analysis toolpak in xl2007, not visible

[Guest]

Hi,
I've installed the analysis toolpak in excel 2007, but can't seem to find
it's commands anywhere (looking for histogram). The help guide says "To
access these tools, click Data Analysis in the Analysis group on the Data
tab. If the Data Analysis command is not available, you need to load the
Analysis ToolPak add-in program."

The problem is, there is no Analysis Group on the data tab. Only Get
External Data, Connection, Sort & Filter, Data Tools, and Outline. I've
looked under Data tools, and it can't be found there either.

Any advice appreciated.

 

[Jim Rech]

there is no Analysis Group on the data tab.

There is for me. All the way to the right after the Outline group.

--
Jim
| Hi,
| I've installed the analysis toolpak in excel 2007, but can't seem to find
| it's commands anywhere (looking for histogram). The help guide says "To
| access these tools, click Data Analysis in the Analysis group on the Data
| tab. If the Data Analysis command is not available, you need to load the
| Analysis ToolPak add-in program."
|
| The problem is, there is no Analysis Group on the data tab. Only Get
| External Data, Connection, Sort & Filter, Data Tools, and Outline. I've
| looked under Data tools, and it can't be found there either.
|
| Any advice appreciated.

 

[Guest]

It works exactly as it says it should for me. The only thing I can think of
is that you didn't actually activate the Add-In correctly. Let's just walk
through the steps to make sure:

1. Click on the "Office Button"
2. Click on "Excel Properties"
3. Select the "Add-Ins" section
4. At the bottom of the window, click the "Go..." button
5. Check "Analysis TookPak"
6. Click OK
7. Select the Data Tab
8. At the far right, you should see the "Analysis" Group after the "Outline"
Group

If its still not working, then I'm at a loss as to what to suggest next.

HTH,
Elkar

 

[Guest]

Unfortunately there's still no analysis group to the right of the outline
group. I went through the process to reinstall the toolpak again, but still
not showing.