1. Hi, I am unable to run the calculator with error “#NAME?”. I have set the folder which contains the add-ins xll file in Excel’s trusted locations, and managed to add the add-ins in Active Application. Please assist.

    1. Author


      This error is generated by Excel when the formula is not recognised. It happens when the xDGA library has not loaded.

      The solution is to open the Excel workbook where you are doing your calculations and then “open” the xDGA library by double-clicking on the DLL file. It is likely that you don’t notice any immediate change. You can press the [F9] key on your keyboard to force Excel to refresh the formulas on your workbook.

      It should all work after this. Let us know if you still have any issues.


      1. Hi, I have tried the F9 key and the problem still persist. I am using 64bit version by the way. I tried it on a fresh Excel sheet with no positive outcome.

        1. Author


          Have you opened the DLL before pressing [F9]? Also, ensure the functions in the formulas have the correct spelling.

          It might be more efficient if you send the file you are using to diagnose the issue

Leave a Reply