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:
- Click File:
- Click Options:
- Click Add-Ins, ensure Manage: Excel Add-ins is selected then hit Go...:
- Click Browse...:
Choose the correct path for your bit-version of Excel:
In the Add-Ins listing, ensure the file selected in step 5 is listed and checked. Click Browse:
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}.
- Ensure both SigmaXL as well as the file selected in step 5 are checked. Click OK:
- Close and Re-Open Excel. You will no longer need to use the SigmaXL desktop icon to open SigmaXL.