| 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 | |||
Linear Mode
