Page Comparison

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 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:
   
   

   Expand
   title Click here for Excel 2016
   Navigate to the SigmaXL installation directory:  Expand title SigmaXL for 32 bit Excel Navigate to C:\Program Files (x86)\SigmaXL\V8 and double click the file SigmaXL_Classic_2016_Ribbon: Expand title SigmaXL for 64 bit Excel Navigate to C:\Program Files\SigmaXL\V8 and double click the file SigmaXL_Classic_2016_Ribbon:

   
   

   Expand
   title Click here for Excel 2013 and Excel 2010
   Navigate to the SigmaXL installation directory:  Expand title SigmaXL for 32 bit Excel Navigate to C:\Program Files (x86)\SigmaXL\V8 and double click the file SigmaXL_Classic_Ribbon: Expand title 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
   title 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.
   
   

   ---

Related articles