Resolve Run-time error '5'

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.
   
   

   ---

Related articles

• Page:
  Troubleshooter - SigmaXL for Mac
• Page:
  Troubleshooter - DiscoverSim
• Page:
  SigmaXL for Windows - Frequently Asked Questions
• Page:
  Troubleshooter - SigmaXL for Windows