Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
analysis toolpak
I bought the Student Ultimate Steal Package online.
I tried to add the analysis toolpak in Excel Option. But I doesn't show up on the ribbon under Data. How do I get this to work? Do I need a physical CD? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
analysis toolpak
Since you said "ribbon", I presume you bought Excel 2007. If so, you don't
have to add the Analysis Toolpak because its functions are now built-in to that version of Excel. -- Rick (MVP - Excel) "Candice" wrote in message ... I bought the Student Ultimate Steal Package online. I tried to add the analysis toolpak in Excel Option. But I doesn't show up on the ribbon under Data. How do I get this to work? Do I need a physical CD? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
analysis toolpak
But I don't see it any where under Data.
HOw do I access it? "Rick Rothstein" wrote: Since you said "ribbon", I presume you bought Excel 2007. If so, you don't have to add the Analysis Toolpak because its functions are now built-in to that version of Excel. -- Rick (MVP - Excel) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
analysis toolpak
My answer dealt with the functions from the Analysis ToolPak, but I see you
want the Data Analysis Tools. Here is how to activate that... 1. Click the Office Button (the big circular icon in the upper left corner 2. Click the Excel Options button 3. Click the Add-Ins entry on the left 4. Select Excel Add-ins from the Manage drop down box at the bottom of the dialog panel and then click the Go button 5. Put a check mark next to the Analysis ToolPak item and click the OK button A Data Analysis panel should now be available on the Data tab. -- Rick (MVP - Excel) "Candice" wrote in message ... But I don't see it any where under Data. HOw do I access it? "Rick Rothstein" wrote: Since you said "ribbon", I presume you bought Excel 2007. If so, you don't have to add the Analysis Toolpak because its functions are now built-in to that version of Excel. -- Rick (MVP - Excel) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
analysis toolpak
I already did that but it still didn't show up on the ribbon under Data.
What do you mean functions from the analysis toolpak? You mean I can do the function without having the Data Analysis Tools? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
analysis toolpak
I have XL2007, but I have not really used it all that much, so I am probably
not the person you need for some of these questions. All I know is that when I added the Analysis ToolPak add-in to my copy of XL2007, the Data Analysis tool panel appeared on the Data tab automatically, so the process I outlined worked for me. The functions I was talking about are the ones that you can use inside of formulas you construct on the worksheet... those functions are supposed to be built in, so if that is what you meant by "functions", then I would advise you to just try using them and see what happens. If you are unsuccessful in your efforts, I would advise reposting your question (adding what you have tried) and see if another of the volunteers here more familiar with XL2007 than me responds. By the way, make sure to mention that you are using XL2007 in that reposting (if you need to repost, that is). -- Rick (MVP - Excel) "Candice" wrote in message ... I already did that but it still didn't show up on the ribbon under Data. What do you mean functions from the analysis toolpak? You mean I can do the function without having the Data Analysis Tools? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Analysis ToolPak Regression Analysis Help Requested | Excel Worksheet Functions | |||
Analysis Toolpak-Confidence Level and data analysis questions | Excel Worksheet Functions | |||
Analysis Toolpak | Excel Worksheet Functions | |||
Analysis toolpak | Excel Discussion (Misc queries) | |||
Analysis ToolPak installed but no Data Analysis option | Excel Discussion (Misc queries) |