Office 2007 Analysis toolpak won't appear in ribbon

R

recif20002002

Hey everyone,

I have just bought an office 2007 but so far i am unable to see the
analysis toolpak in the ribbon (Excel).
The tookpak is installed and active but it just doesn"t appear. It is
very strange. I ve seen a couple of posts online but i didn t find any
clear answer.

I have to say that i decided to keep my version of excel 2003 while i
get use to it (apparently it might come from this)


thank you
 
R

Ron Rosenfeld

Hey everyone,

I have just bought an office 2007 but so far i am unable to see the
analysis toolpak in the ribbon (Excel).
The tookpak is installed and active but it just doesn"t appear. It is
very strange. I ve seen a couple of posts online but i didn t find any
clear answer.

I have to say that i decided to keep my version of excel 2003 while i
get use to it (apparently it might come from this)


thank you
Click to expand...

The ATP functions have been made an integral part of Excel 2007. No
requirement for the add-in.

If you look at the functions, you will see the ATP functions listed there.
--ron
 
M

Mike Middleton

recif20002002 -

You didn't say where you looked, so, just to be sure you know where to look,
when the Analysis ToolPak is installed in Excel 2007, it appears on the far
right of the Data ribbon in the Analysis group.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel
 
R

recif20002002

The ATP functions have been made an integral part of Excel 2007. No
requirement for the add-in.

If you look at the functions, you will see the ATP functions listed there.
--ron
Click to expand...

I know the pack is supposed to be installed in the Data ribbon on the
far right but it just doesn't appear even though everything is
installed properly
 
R

Ron Rosenfeld

I know the pack is supposed to be installed in the Data ribbon on the
far right but it just doesn't appear even though everything is
installed properly
Click to expand...

Why do you want to install it?
--ron
 
R

Ron Rosenfeld

Why do you want to install it?
--ron
Click to expand...

I ask that question because, as I wrote before:

"The ATP functions have been made an integral part of Excel 2007. No
requirement for the add-in."

--ron
 
R

Ron Rosenfeld

Well i need to be able to use the correlation covariance and
descriptive statistics function.
What does ATP actually means?
Click to expand...

OK, I see you want to use the wizards.

The functions within the ATP (Analysis ToolPak) are part of native Excel, but
the wizards require the installation of the ATP.

Check the following to be sure the ATP is properly installed.

Press the Office button in the upper left hand corner of the Excel window.
Select Excel Options down at the bottom of the window that opens, just
next to "Exit Excel"

From the Left hand menu, select Add-Ins

You will see a screen with two sections;
the top section is the list of "Active Application Add-ins";
the bottom section is the list of "Inactive Application Add-ins".

In which list does "Analysis ToolPak" appear?
--ron
 
R

recif20002002

OK, I see you want to use the wizards.

The functions within the ATP (AnalysisToolPak) are part of native Excel, but
the wizards require the installation of the ATP.

Check the following to be sure the ATP is properly installed.

Press the Office button in the upper left hand corner of the Excel window.
Select Excel Options down at the bottom of the window that opens, just
next to "Exit Excel"

From the Left hand menu, select Add-Ins

You will see a screen with two sections;
the top section is the list of "Active Application Add-ins";
the bottom section is the list of "Inactive Application Add-ins".

In which list does "AnalysisToolPak" appear?
--ron
Click to expand...

Hey sorry i got so focused on my assignments that i forgot about this
post.

The analysis toolpak appears in the active application add-ins.
I ve tried using the go button under to activate and desactivate it
but it still won't show up in the ribbon
 
R

Ron Rosenfeld

The analysis toolpak appears in the active application add-ins.
I ve tried using the go button under to activate and desactivate it
but it still won't show up in the ribbon
Click to expand...

Hmmm. You mentioned you were looking at the Data ribbon (not the Add-Ins
ribbon). The Data ribbon is where it shows up on my machine, so I guess that's
correct.

The name is "Data Analysis" and at the bottom it says Analysis.

I guess I can't help you further, unless there's something running on your
machine that is modifying the ribbon.

Or unless you didn't recognize that "Data Analysis" is the name shown for the
"Analysis ToolPak".
--ron
 
Top