analysis toolpak

  1. D

    Multiple regression issues in analysis toolpak

    Dear MrExcel community, Is there any easy and automatic way to compute predictions including confidence intervals after a multiple regression using the Analysis Toolpak? Also, the analysis toolpak regression tool reports an error whenever I have missing data points in my range selection. What...
  2. E

    Macro Crashes Excel b/c of Analysis ToolPak (Automation Error Exception Occurred)

    Hi, not sure if this is a known issue but I didn't see its solution in any of the message boards I was looking at. I was running a macro I built a while ago and every single time Excel would freeze and I'd get the "Automation Error Exception Occurred" message box. After searching and...
  3. M

    Calling Analysis ToolPak From VBA 2003 & 2007

    I know there have been threads on this, but I have not found any that comprehensively compare and reconcile practices for Excel 2003 and 2007. What I think I have found is: In 2003, I can call eomonth and workday, for example functions, either unqualified, or qualified with [atpvbaen.xls]. In...
  4. 1

    Predictive Modeling Using Data Analysis Tool Pak

    Hi Everyone, Looking for some assistance with the Data Analysis Tool Pak. I went to a class that mentioned predictive modeling could be done using the DA Tool Pak... I can't figure it out. :banghead: Anyone ever used the DA Tool Pak for predictive modeling? Any help is appreciated...
  5. J

    Excel 2010 funcres reference issue

    I have an excel 2003 workbook that is crashing in excel 2010. The workbook is crashing due to a reference to funcres created in vba. I do have the 'Analysis ToolPak' addin checked which is tied to funcres. Yet, I can't find funcres when I go to References under Tools when I'm in the Visual...
  6. M

    2003 / 2010 Macro Compatability (Edate)

    Hi all, I have tried to search around for this so please forgive me if this is an issue previously covered. At work we use Excel 2003, wheras at home I have Excel 2010. I'm having some problem using work spreadsheets at home, specifically running macros with Edate and Yearfrac in. I think...
  7. J

    Analysis Toolpak Add-in Installs in French

    Hello, I am attempting to install the analysis toolpak for Excel 2007, and when I do so it shows up in the ribbon in French, and all of the language used within it is in French. Does anyone know of a solution to this? Thanks
  8. R

    Xirr

    I am trying to use XIRR, and it won't recognize the function! I have both the Analysis ToolPak and the Analysis ToolPak VBA add-ins checked under tools. What else could be causing Excel not to recognize the function? I tried using it as "Insert, Formula" but that did not work, either! Weird. TR

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top