|
|
|
|
|
|
|
|
|
|
| |
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.
|
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
 Reply |
| |
 |
|
 Top |
|
|
|
|
|
|
|
| |
 Answer |
|
| |
Jeff
The Analysis Toolpak is installed with Excel.
It is not a download.
Load it through Tools>Add-ins and checkmark it.
For a list of where 2007 menu commands are located see Ron de Bruin's site.
http://www.rondebruin.nl/0307commands.htm
Gord
On Sun, 8 Jul 2007 08:46:02 -0700, JeffM <JeffM@discussions.microsoft.com>
wrote:
>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.
|
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
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
"Roger Govier" wrote:
> 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.
> --
> Regards
>
> Roger Govier
>
>
> "JeffM" <JeffM@discussions.microsoft.com> wrote in message
> news:163F4FC4-17FA-42A0-A8BA-A9B5BC15A07E@microsoft.com...
> > 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
>
>
> |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Question
Notify me of replies