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

   Expand
   title SigmaXL for 32 bit Excel
   Navigate to C:\Program Files (x86)\SigmaXL\{Version Number} and double click the file SigmaXL_Classic_2016_Ribbon:

   
   

   Expand
   title 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
   title 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.
   
   

   ---

Related articles