MS Excel Data Analysis toolpak question

Question

Level 1

4 points

MS Excel Data Analysis toolpak question

Attempted to add data analysis toolpak to MS Excel using MS Office 2004 for Mac.

However, when I attempt to load/add the program, a folder is added containing Data Analysis is listed but "Data Analysis" does not show up in my MS Excel "Tools" tab.

Probably an easy fix. Any assistance is appreciated - thanks.

Posted on Jul 13, 2008 11:50 AM

Reply

Answer 1

WWJD

Level 6

15,830 points

Jul 13, 2008 2:34 PM in response to uriwvu

Please confirm that you have loaded the add-in when Excel Starts, you'll see the loading at the message bar at the bottom of the Excel window. Are you using the 2004 version of Analysis ToolPak?

Regards,

First:

Second:

Third:

Reply

Answer 2

uriwvu Author

Level 1

4 points

Jul 14, 2008 5:45 AM in response to WWJD

Yes I have the 2004 MS Office for Mac installed. However, I cannot confirm that the add in has been loaded when using Excel.

The procedure that I am using:
1. With MS Excel open, I go into the "Tools" tab and select "Add-ins"
2. The "Add-ins" sub-box opens and I check the desired utilities, in this case Analysis Toolbox and I hit the "Select" button.
3. Next another sub-box opens entitled, "Choose an Add-in". With the MS Office CD in I scroll oven until I locate the sub-folder "Analysis Tools" which opens up four additional options: Analysis ToolPak, Analysis ToolPak - VBA, FuncRes, and ProcDBRes. I select Analysis ToolPak and then "Open".
4. I receive a pop up message, "Copy Analysis ToolPak to the Add-ins folder?" I select "yes" .
5. Thinking that the process has been completed, I go back to the MS Excel worksheet, select "Tools" tab and Data Analysis is not there.

Reply