Office 2007 Analysis toolpak won't appear in ribbon

  • Thread starter Thread starter recif20002002
  • Start date Start date
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
 
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
 
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
 
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
 
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
 
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
 
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
 
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
 
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
 
Back
Top