Resolve Run-time error '5'

Owned by Paul Petrin
Last updated: Jul 19, 2024
1 min read

Resolve Run-Time error 5: Invalid procedure call or argument

When opening SigmaXL, you receive the following error message:



 The error can be resolved by completing the following:

  1. Click File:



  2. Click Options:



  3. Click Add-Ins, ensure Manage: Excel Add-ins is selected then hit Go...:



  4. Click Browse...:



  5. Choose the correct path for your bit-version of Excel:

     SigmaXL for 32 bit Excel

    Navigate to C:\Program Files (x86)\SigmaXL\{Version Number} and double click the file SigmaXL_Classic_2016_Ribbon:


     SigmaXL for 64 bit Excel

    Navigate to C:\Program Files\SigmaXL\{Version Number} and double click the file SigmaXL_Classic_2016_Ribbon:


  6. In the Add-Ins listing, ensure the file selected in step 5 is listed and checked. Click Browse:

     

  7. Navigate to C:\Program Files (x86)\SigmaXL\{Version Number} and double-click SigmaXL:



    Note for 64 bit Users

    64-bit users must browse to the directory: C:\Program Files\SigmaXL\{Version Number}.


  8. Ensure both SigmaXL as well as the file selected in step 5 are checked. Click OK:



  9. Close and Re-Open Excel. You will no longer need to use the SigmaXL desktop icon to open SigmaXL.

Frequently asked questions

Need more help?

Other resources