Jan 30, 2017 I am using an iMac with OS X El Capitan Version 10.11.6 with Excel for Mac Version 15.29 (came as part of Office 365 for Home) I have downloaded and have been using Analysis Toolpak, specifically Fourier Analysis but as a spreadsheet function.
- Excel Analysis Toolpak for Mac 02 February| how-to, interests, tech news| Rob If your a student such as myself and use a Mac, you have probably run into a few complications in certain course work.
- I'm running Excel 2011 for Mac. The instructor mentioned that it may be available as an add in download but I'm not able to find it. If someone could please point me in the right direction (or confirm if it really is an option) I would appreciate it.
Data Analysis Toolpak Excel For Mac
I'm trying to run the Regression function from the Analysis Toolpak in VBA. When I run the code below I get
'Run-time error '1004':
Application-defined or object-defined error'
When I try to record the regression with a macro, nothing shows up in the macro.
I think the problem is that I do not have Analysis Toolpak-VBA. The add-ins that I have installed is Analysis Toolpak and Solver. These are the only options I get to pick when I try to install add ins. How do I get Analysis Toolpak-VBA for Mac Excel 2016?