Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 13 Next »

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 file specific to your version of Excel:

     Click here for Excel 2016
    Navigate to the SigmaXL installation directory: 

     SigmaXL for 32 bit Excel

    Navigate to C:\Program Files (x86)\SigmaXL\V8 and double click the file SigmaXL_Classic_2016_Ribbon:


     SigmaXL for 64 bit Excel

    Navigate to C:\Program Files\SigmaXL\V8 and double click the file SigmaXL_Classic_2016_Ribbon:


     Click here for Excel 2013 and Excel 2010

    Navigate to the SigmaXL installation directory: 

     SigmaXL for 32 bit Excel

    Navigate to C:\Program Files (x86)\SigmaXL\V8 and double click the file SigmaXL_Classic_Ribbon:


     SigmaXL for 64 bit Excel

    Navigate to C:\Program Files\SigmaXL\V8 and double click the file SigmaXL_Classic_Ribbon:


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

     

  7. Navigate to C:\Program Files (x86)\SigmaXL\V8 and double-click SigmaXL:



    Note for 64 bit Users

    64-bit users must browse to the directory: C:\Program Files\SigmaXL\V8.


  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.





  • No labels