Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Issue

SigmaXL is not working or my results appear incomplete.

...

Panel
bgColor#DEEBFF

This troubleshooter is for SigmaXL for Windows. Click here for the SigmaXL troubleshooter for Mac.

...

  1. Clear SigmaXL Saved Defaults

  2. Ensure the bit-version of Excel matches the installed bit-version of SigmaXL

  3. Ensure all applicable C++ Redistributable Libraries have been installed

  4. Ensure SigmaXL is compatible with your version of Excel 

  5. Ensure Microsoft Excel is up to date

Anchor
CSD
CSD

Step 1. Clear SigmaXL Saved Defaults 

...

Many issues can be resolved by simply clearing SigmaXL’s saved defaults. To do this, click SigmaXL > Help > SigmaXL Defaults > Clear Saved Defaults:

Clear Saved Defaults in SigmaXLImage RemovedClear Saved Defaults in SigmaXLImage Added

...

Anchor
BitMatched
BitMatched

Step 2. Ensure the bit-version of Excel matches the installed bit-version of SigmaXL

...

  • 64-bit: C: \ Program Files \ SigmaXL

  • 32-bit: C: \ Program Files (x86) \ SigmaXL

If SigmaXL is installed in the wrong folder for your bit-version of Excel, completely uninstall, then reinstall SigmaXL.

...

Visual Basic C++ redistributable libraries are available in both 32-Bit and 64-Bit versions. The versions version you will require is determined by your bit version of Microsoft Office, not your bit version of Windows. Download and install all 4 the correct redistributable for your bit-version of Excel.

Redistributables

Redistributable for 32-bit installations of MS Office 

Visual Studio C++ 2015-

2019

Visual Studio C++ 2013

Visual Studio C++ 2012 Update 4

Visual Studio C++ 2010

Redistributables

2022


...

Anchor
Compatibility
Compatibility

Step 4. Ensure SigmaXL is compatible with your version of Excel 

...

Issues can sometimes occur if MS Excel is not up to date. Confirm that the most recent updates for your version of Office have been installed.

  1. Open Excel and click File:

    Image Modified

  2. Click Account:

    Image Modified

  3. Click the Update Options button:

    Image Modified

  4. Select Update Now:

    Image Modified

  5. If updates for Office are available, you will be presented with the following. Please allow some time for the updates to complete:

    Image Modified

  6. When the updates are finished installing, the Microsoft update window will disappear and Excel can be opened.

Note

Excel versions 2010 2013 and older are no longer supported by Microsoft or SigmaXL.


...

Should the issue persist after confirming the belowabove, please contact SigmaXL technical support for further assistance:

Technical support hours are Monday-Friday from 8:00 am - 5:00 pm Eastern Time (Excluding CDN Holidays)

...