View Single Post
  #4  
Old September 23rd, 2008, 07:00 PM posted to microsoft.public.excel.worksheet.functions
David Biddulph
external usenet poster
 
Posts: 8,714
Default No Data Analysis item in Excel Tools menu. Now what?

It needs to be not only installed but enabled (under Tools/ Addins).
If that looks OK you could try disabling the Add-in, coming out of Excel (&
possibly rebooting your machine), then re-opening Excel and re-enabling the
Add-in. Excel does sometimes "forget" that the add-in was enabled.

Or going back to the last bit of your message, "Data Analysis" won't appear
on the Tools menu if you are looking at a chart, rather than a worksheet.
The menus for a chart are very different from the menus for a worksheet.
Data Analysis is a worksheet function, not a chart function. Go to a
worksheet, rather than a chart, and look again at your Tools menu.
--
David Biddulph

"hoakland" wrote in message
...
What if the ToolPak is installed but will not appear in tool menu on a
worksheet with graph displayed.

"David Biddulph" wrote:

The answer, as for so many questions, is in Excel help:
"If the Data Analysis command is not available, you need to load the
Analysis ToolPak add-in program."
--
David Biddulph

"ainoni" wrote in message
...
How do I get the Data Anlysis (for regression) into my Tools menu?