Please follow this quick guide to check if your MAC meets all the requirements XLSTAT needs to work properly.
XLSTAT is compatible with both Microsoft Office 2011 & 2016.
Requirements for Microsoft Office 2016
XLSTAT is compatible with all versions of Excel 2016 starting from 15.30.
Requirements for Microsoft Office 2011
Excel Mac 2011 should have at least the Service Pack 1 installed. See below how to verify this.
1. Checking your version:
Open the Excel menu on your menu bar, then click on About Excel.
The Latest Installed Update should be at least 14.1.0, which corresponds to the Service Pack 1.
If your version is older than that, please refer to the Updating section below.
It is recommended though to install all three Service Packs so your Excel is up-to-date.
2. Updating Office:
A guide on how to update Office for Mac can be found here.
XLSTAT requires VBA to be installed along with Office 2011.
1. Checking your VBA installation:
A quick way to check if VBA is installed is to verify whether the library file can be found.
Open the Finder and access the Applications list.
Browse to this location: Microsoft Excel > Office > Type Libraries.
If VBA is installed you should be able to locate the Excel 14 Type Library file in this directory.
If the file is not located in this folder, please refer to the section below.
2. Installing VBA:
For VBA to be installed along with Office 2011, you should activate a checkbox within a Custom Install process.
Run the Microsoft Office Installer. Upon arriving on the Installation Type panel, click on Customize.
On the Custom Install screen, please deselect all checkboxes if Office 2011 is already installed on your MAC.
Expand the Microsoft Office 2011 line by clicking on the triangle, then make sure that Visual Basic for Applications is checked before clicking on Install.
Once the installation is over, VBA should be installed on your Mac.