Office 2K XL question please

  • Thread starter Thread starter 1.156
  • Start date Start date
1

1.156

I want to do an FFT on some data so in the HELP system I find I must
install the Analysis ToolPak. It even tells me how to install it:

"To install the Analysis ToolPak
On the Tools menu, click Add-Ins. "

Only problem is that there's no TOOLS on my menu. My top menu items are
FILE EDIT VIEW INSERT FORMAT DATA WINDOW HELP.

I looked everywhere for some other menu with TOOLS in it with no luck.
I did find a "Toolbar" but I saw nothing about any Analysis or Add-Ins.
If I ever get it installed, I'll need the TOOLS menu again for the HELP
tells how to use it:

"To use the Analysis ToolPak
On the Tools menu, click Data Analysis"

Would someone here be kind enough to tell me how to get a TOOLS menu on XL?

Thanks, Rob
 
On your menus
View -> Toolbars -> Customize...
Under the Categories pick "Built -in Menus"
Scroll down in the commands till you find "Tools" and drag and drop
it into your menus (mine's between Format and Data)

Dan E
 
Tools>Customize>Toolbars. Select "Worksheet Menu Bar" and "Reset".

Note: this will delete any customizations you have made to the menu.

Gord Dibben Excel MVP
 
Dan, thanks a lot. That was one giant leap- now I actually have a TOOLS
menu item. Unfortunately, the very next step fails. Note I said the
second need for the TOOLS menu was when using this Add-In. It says

"To use the Analysis ToolPak

On the Tools menu, click Data Analysis"

There is no Data Analysis selection in this TOOLS menu. Looks like Bill Gates got in my knickers again.

But thanks a lot for the help.

Rob
 
A step has been skipped

Tools -> Add-ins

On the pop - up menu check "Analysis ToolPak" and hit OK
-> depending on how you installed excel, you may need your
office/excel discs

This installs the add-in. When done you should find Data
Analysis under the Tools menu.

Dan E
Dan, thanks a lot. That was one giant leap- now I actually have a TOOLS menu item. Unfortunately, the very next step fails. Note
I said the second need for the TOOLS menu was when using this Add-In. It says

"To use the Analysis ToolPak

On the Tools menu, click Data Analysis"

There is no Data Analysis selection in this TOOLS menu. Looks like Bill Gates got in my knickers again.

But thanks a lot for the help.

Rob



Dan E wrote:

On your menus
View -> Toolbars -> Customize...
Under the Categories pick "Built -in Menus"
Scroll down in the commands till you find "Tools" and drag and drop
it into your menus (mine's between Format and Data)

Dan E


I want to do an FFT on some data so in the HELP system I find I must
install the Analysis ToolPak. It even tells me how to install it:

"To install the Analysis ToolPak
On the Tools menu, click Add-Ins. "

Only problem is that there's no TOOLS on my menu. My top menu items are
FILE EDIT VIEW INSERT FORMAT DATA WINDOW HELP.

I looked everywhere for some other menu with TOOLS in it with no luck.
I did find a "Toolbar" but I saw nothing about any Analysis or Add-Ins.
If I ever get it installed, I'll need the TOOLS menu again for the HELP
tells how to use it:

"To use the Analysis ToolPak
On the Tools menu, click Data Analysis"

Would someone here be kind enough to tell me how to get a TOOLS menu on XL?

Thanks, Rob
 
Dan, you got it all covered. Damn if I'm not Fouriering away now.
Thanks a lot for helping out an XL challenged individual.
Rob
 
Back
Top