Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
No Data Analysis item in Excel Tools menu. Now what?
How do I get the Data Anlysis (for regression) into my Tools menu?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
No Data Analysis item in Excel Tools menu. Now what?
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
No Data Analysis item in Excel Tools menu. Now what?
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
No Data Analysis item in Excel Tools menu. Now what?
If the Chart is selected you will get a different menu.
Do not select the Chart on the worksheet and you will see ToolsData Analysis. Gord Dibben MS Excel MVP On Tue, 23 Sep 2008 08:45:26 -0700, hoakland wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data analysis tools | Excel Worksheet Functions | |||
I added analysis toolpack, but does not appear in tools menu | Excel Discussion (Misc queries) | |||
Cannot use Data Analysis tools on Excel worksheet embedded in PwrP | Excel Worksheet Functions | |||
Data Analysis Options disappears from |
Excel Discussion (Misc queries) | |||
How do I get Data Analysis Plus tool pack in tools menu Show up. . | Setting up and Configuration of Excel |