Refedit problem

Question

Hello everyone

I have problem running XLSTAT in Excel 2016 in Window 10.

I have contacted XLSTAT supprot center and tried several methods they provided, and they concluded it's "refedit" problem.

So the symptom of the error is whenever I try to run XLSTAT function, it gives error saying

"Run-time error '1004: Cannot run the macro 'RunFormXXX(name of the function)'. The macro may not be available in this workbook or all macros may be disabled.

I have tried 

1. excel - option-trust center - macro setting - change macro setting to all 4 options while 'Trust VBA' option selected (- restart/repair whole microsoft office)
2. windon-run- deleting all 'refedit' files (- restart/repair whole microsoft office)

and I also ran the sample macro excel file (xlsm) and it created error such as 

"System error &H80070057 (-2147024809). The parameter is incorrect."

Then it opens 'Microsoft Visual Basic for Applications'

As you may noticed, I am not good at programming and stuff..

Please help me !

Answer 1

(A) Are you able to run the add-ins provided by Microsoft for Excel, like Analysis ToolPak and Solver?

(B) From many years ago, I recall some RefEdit problems that were related to Excel's temporary EXD files. At that time a solution was to delete all EXD files, so that the next time you start Excel a new updated version of the EXD files would be automatically created. As far as I know and based on my own experience yesterday, there's no risk in trying this solution: Quit Excel. Run the Windows 10 File Explorer. In File Explorer, in the left pane select This PC > Windows (C:), in the View ribbon check the boxes for File Name Extensions and for Hidden Items, in the Search box on the far right type "*.exd" without the quotes, and press Enter. The search may take a minute or more. Delete the two RefEdit.exd files and the MSForms.exd file. Optionally, press F5 to refresh File Explorer to verify that the EXD files no longer exist. Start Excel. Test your add-ins.

Answer 2

Thanks alot.

(A) Yes other add-in is working, for example, Analysis Toolpak (from Microsoft) is working.

(B) I followed your instruction and deleted the 3 exd files. After I re-open the excel but the XLSTAT is still not working..

Do you have other suggestion, or is it possible that Excel technical center connect to my laptop and solve the problem..?

Thanks alot.

Answer 3

Dear Mike Middleton

Thanks for your reply !

1. No, I haven't tried deleting EXD files.
2. the 'sample macro excel file' was meant to run a macro to see if it's macro problem..

In the end the XLSTAT help center concluded the error comes from 'broken refedit'.

Thanks alot.. help me if you know any suggestion :)

Thanks

Answer 4

BHLEEE -

(A) You wrote "tried several methods they provided." Did that include removing EXD files?

(2) You wrote "ran the sample macro excel file (xlsm)." What is the xlsm file supposed to do?

• Mike Middleton