Run-time error ‘1004’ – Excel cannot access XLSTAT.xla (Windows)

CASE 1

You may encounter a Run-time error ‘1004’ right after opening XLSTAT:

It is highly possible that a third-party program is blocking XLSTAT.xla file and potentially other files from the installation folder of XLSTAT.

To solve this problem, you must find the Antivirus which is blocking the files. Once you have found, please proceed as following:

Release the XLSTAT files from the quarantine.
Add XLSTAT installation folder into the whitelist (or exception) of your Antivirus. It is possible that your Antivirus doesn’t allow you to add an entire folder into the whitelist, in that case it means that you will have to add manually each file from the XLSTAT installation folder, it’s a tedious work but necessary.
Repair XLSTAT.
Go to the Apps & Features (right click on the Windows Start).

Select XLSTAT program and click on Modify.

Select Repair and let it do.

CASE 2

You encounter a Run-time error ’1004’ when running an analysis:

In that case, there are two possibilities:

The cause is your antivirus. Please refer to the previous section.
If you recently changed your Microsoft Office from 32-bit to 64-bit version, it is possible that one of the registry key which is necessary for running XLSTAT analysis didn’t update correctly. To do it by yourself, you will need to have administrator rights, then follow this procedure:
Press Windows key+R, write REGEDIT and click OK.

Once you are in the Registry Editor, press Ctrl+F and look for the key REFEDIT.DLL.

Here you are able to see the path of the REFEDIT.DLL file. If it is in the folder starting with “C:\Program Files (x86)\” it means that the file is still attached to the 32-bit Office version, that’s why you must modify it.