Google Groupes n'accepte plus les nouveaux posts ni abonnements Usenet. Les contenus de l'historique resteront visibles.

installed analysis toolpak in xl2007, not visible

104 vues
Accéder directement au premier message non lu

Eddie O

non lue,
28 juin 2007, 15:16:0428/06/2007
à
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

non lue,
28 juin 2007, 15:49:0828/06/2007
à
>>there is no Analysis Group on the data tab.

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

--
Jim
"Eddie O" <Edd...@discussions.microsoft.com> wrote in message
news:100B2830-606C-453B...@microsoft.com...

Elkar

non lue,
28 juin 2007, 15:56:0628/06/2007
à
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

Eddie O

non lue,
2 juil. 2007, 11:56:0202/07/2007
à
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.
0 nouveau message