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 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 bit-version of Excel:
   

   ExpandtitleClick here for

   Excel

   2016Navigate to the SigmaXL installation directory

   :

    

   
   
   

   Expand
   title SigmaXL for 32 bit Excel
   Navigate to C:\Program Files (x86)\SigmaXL\ V8  V9.1 and double click the file SigmaXL_Classic_2016_Ribbon: Image Removed Image Added

   
   

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

   V9.1 and double click the file SigmaXL_Classic_2016_Ribbon:
   

   Image Removed
   

   Expand
   title SigmaXL for 64 bit Excel
   Navigate to C:\Program Files\SigmaXL\ V8Navigate to the SigmaXL installation directory:
   Expand
   title SigmaXL for 32 bit Excel
   Expand
   title SigmaXL for 64 bit Excel
   Expand
   title Click here for Excel 2013 and Excel 2010
   Image Added

   
   

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 V9.1 and double-click SigmaXL:
   Image Removed
   Image Added
   
   

   Note
   title Note for 64 bit Users
   64-bit users must browse to the directory: C:\Program Files\SigmaXL\V8V9.1.

   
   

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