where is the Analysis Group in Excel?

J

JeffM

I downloaded a Statistical Add-on for Excel. According to the help entry, I
am to look for the Analysis Group under the Data Tab and then click on Data
to activate the add-on. Only problem is is that there is no Analysis Group
when I click on the Data Tab. Nor is there an entry in the Help index for
either Data Tab or Analysis Group.

It is this kind of thing that turns people into Luddites.
 
G

Gord Dibben

Downloaded to where?

What is the name of the add-in and have you enabled it under Tools>Add-ins?

Your add-in should be adding the menu items to your Excel Data menu.

Excel help would have no entry for assistance with a third-party add-in.


Gord Dibben MS Excel MVP
 
J

JeffM

First, thanks Gord for the assistance.

Second, the name of the add-in is Analysis ToolPak. I believed it was from
Microsoft. And it is covered in Help. But the section in Help refers to other
items, such as a Data Analysis Group, that are not in Help. Annoying but not
your problem. I have sent a nasty gram to Microsoft about it.

Third, one of my problems with Excel 2007 is that I have not found an icon
for Tools. It may be there somewhere, but I have not found it as yet. Nor
have I found how to activate it in Help. Quite annoying, but maybe it
represents my incompetence, something my wife stresses frequently.

Fourth, and most mysterious, NOW there is a Data Analysis Tab under the Data
Tab. Perhaps, I needed to reboot before it appeared because it was not there
yesterday.

Again thanks for the help.

PS The add-in is pretty slick.
 
J

JeffM

Gord

Thanks again for the help. Analysis Toolpak seems to need to be configured
or something in Excel 2007 before it is available. (Maybe because I started
by downloading a trial version and then buying it.) Anyway, it is not hard to
do.

I also checked out the page on the web site you recommended. Pretty cool. It
basically tells you where to find commands in Excel 2007 that you may have
used in earlier versions of Excel. Unfortunately, "Tools" no longer seems to
exist as a Tab label in Excel 2007. I suspect this is going to take some
getting used to.

I have Analysis Toolpak working fine now.

Jeff
 
G

Gord Dibben

Good hunting<g>

I have not yet upgraded to 2007.

The steady advancement towards septugenarianism makes everything a steep curve.


Gord
 
R

Roger Govier

Hi Jeff

Alt T starts the Tools dialogue, so Alt T O brings up Options, the same
as clicking the round Office Button>Excel options
Alt T M M will bring up Macros

But for some reason, Alt T D brings up Document management, rather than
Data Analysis, maybe this is because Data Analysis is now on the Data
tab as you have found.

In order for it to appear, you must have Analysis Toolpak ticked
Alt T O >Addins>at bottom of page, Manage Excel Addins>Go>tick Analysis
Toolpak.
 
J

JeffM

Roger

Thanks

While I was messing around on Saturday trying to get things to work, I
managed to find that page and do that. That must have been what got it going,
but by that time I was so exasperated that I must have missed the fact that
my problem was solved. So when I booted on Sunday ....

Anyway, you and Gord have taught me stuff that pure messing around was not
too likely to elucidate

Jeff
 
D

Dave Thomas

You select Office Button/Excel options/add-ins The at the bottom you will
see a box labeled Manage: and in the box Excel add-ins. Select go.
Then select Conditional sum wizard, Lookup wizard, Solver add-ins. And if
your add-in appears here select it too. Then press OK. It will take a bit to
install the addins. Excel 2007 does them one at a time slowly. After doing
so, you will have an Analysis Group with Solver in it at the right in the
Data tab. If your add-in is not there, then repeat the process, but instead
of Excel-addins, look under com in the selection box where Excel
addins-appears. Your add-in may be there. If not you'll have to find it
 
G

georgef

My "analysis group" disappeared... it was there yesterday! GDit ... excel
2007 is a pain in the a$$
 
M

Michael

Hi Gord,

I also have a problem with addin to excel 2007. I loaded the program and
excel accepted it. However a message came up "Object library invalid or
contains references to object definitions that could not be found" Is this
preventing the program from running. If not, just like Jeff i cant find where
in excel to find the program.

Note that before i upgraded to excel 2007, the add in program was working
perfectly in 2003. I uninstalled 2007 and reinstalled 2003 however i
experienced the same message and cant utilize the program.

Please help
 
B

Byron

Hi all,

I have a problem with tis Solver add in. it shows there no file available in
my C:\Users\User\AppData\Roaming\Microsoft\AddIns. Anyone has a solutions?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with the error: unable to filter on excel hc home school 0
Found few bugs in my daily routine of work in excel for MAC 0
Found few bugs in my daily routine of work in excel for MAC 0
Setup and synchronization of Outlook 2016/2019 calendars on iPhone 0
Dates In Excel 5
Setting up and synchronizing Outlook calendars on iPhone 0
Automatic Emails sent to my Contact Groups by Microsoft 1
Data Analysis with Excel 2007 4

Top