How to run XLSTAT the first time?

Important:

Whatever your Excel or XLSTAT version, it is necessary that the Macros security level is set to Medium so that XLSTAT can run.

For Excel 97 to Excel 2003: Use the menu Tools/Macros/Security of Excel

In Excel 2007 a different setting is used:

1. Click the "Office Button" on the upper left corner of the Excel window to open the Office Menu.
2. Click on the "Excel Options" button on the bottom of the Office menu window.
3. Select "Trust Center" in the middle of the menu bar on the left.
4. The "Excel Options" window will appear.
5. Click on the "Trust Center Settings..." button on the right of the window.
6. The "Trust Center" window will appear.
7. Select "Macro Settings" in the middle of the menu bar on the left
8. Select the third or fourth option for the "Macro Settings"
9. Activate the Option "Trust access to the VBA project object model"
10. Click OK to close the "Trust center" window
11. Click OK to close the "Excel options" window

Required/recommended Excel updates:

• Excel 97 SR-1 users: your Excel version must be updated. Version SR-1 is buggy and you need to upgrade to SR-2. You can download an upgrade for free from http://office.microsoft.com/officeupdate. Then proceed to the second step (see below).
• Excel 97 SR-2 users: your Excel version must be updated if you want XLSTAT functions to run well. All you need to do is download the free patch available on http://office.microsoft.com/downloads/9798/xl8p10pkg.aspx.
• Excel 2000 SR-1 or SR-2 users: we recommend that you upgrade your Excel version to SR-3. All you need to do is download the free patch available on http://office.microsoft.com/officeupdate.
• Excel 2002 SP-1 (Office XP) users: we recommend that you upgrade your Excel version to SP-2 available on http://office.microsoft.com/officeupdate.
• Excel 2003 users: we recommend that you download the security patches available on http://office.microsoft.com/officeupdate.

To run XLSTAT for the first time, you can either choose the option to start XLSTAT after the installation procedure, use the Windows Start/Programs/Addinsoft/XLSTA 2006 command, use the XLSTAT shortcut on your desktop, or launch Excel, then open the XLSTAT.xla file using the Excel open command.

XLSTAT will then prompt you for your license number (see below). If you do not have one yet (if, for instance, you've only downloaded the trial version of XLSTAT), please enter "Evaluation" and click "OK".

If you are using XLSTAT for the first time, XLSTAT will add a new button in the Excel standard toolbar. The button can be used to open XLSTAT when you are using Excel and can be removed if you wish. This button can also be used to close XLSTAT.

After completing this procedure, the XLSTAT toolbar and the XLSTAT menu will be added to Excel (see image below). Both the toolbar and the menu allow the user to access all XLSTAT functionalities.

The XLSTAT toolbar can be used to access sub-toolbars. By leaving the cursor on a button, you can view the corresponding function. By clicking on it, you activate the dialog box corresponding to the function selected.

Click here for other tutorials.