Run-time error ‘1004’: Excel cannot access a .xla file (Windows)

CASE 1 - When starting XLSTAT

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

This image serves merely as an illustration, it's possible that the blocked file is not XLSTAT.xla, but any file with a .xla or .xlam extension.

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:

1. Release the XLSTAT files from the quarantine.

2. 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.

3. Repair XLSTAT.

4. 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 - When running an analysis

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

This image serves merely as an illustration, it's possible that the blocked file is not XLSTAT-DIS.xla, but any file with a .xla or .xlam extension.

In that case, there are two possibilities:

1. The cause is your antivirus. Please refer to the previous section.

2. 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.

• Open the File Explorer and Go to C:\Program Files\Microsoft Office. Here, write refedit.dll in the search bar and start searching.

• Once the file is found, right click on it and select “Open file location”.

• Click on the address bar and copy the path (Ctrl+C to copy).

• Go back to the Registry Editor, right click on the (Default) key of REFEDIT.DLL and select Modify…

• Remove all the text before \REFEDIT.DLL and paste the path you previously copied (Ctrl+V to paste).

You should now be able to run XLSTAT properly.

If you need our help, feel free to contact us following this link: https://www.xlstat.com/en/contact/support