Skip to main content

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

CASE 1

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

image.png

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

image.png

Select XLSTAT program and click on Modify.

image.png

Select Repair and let it do.

image.png

CASE 2

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

image.png

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:

  3. Press Windows key+R, write REGEDIT and click OK.

image.png

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

image.png

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.

image.png

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

image.png

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

image.png

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

image.png

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

image.png

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

image.png

image.png

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

Was this article useful?

  • Yes
  • No