The software has extensive error-trapping.  In most cases, the software will catch something that is wrong and let you know what the problem is.  If there is an unknown error, you will get a message box that contains the error description. If the error continues, please send the workbook to [email protected] with a description of the problem. 

VBA Password Prompt

This issue occurs when you close Excel and you get the prompt below asking you to enter a password for SPC for Excel.

vba passwod prompt

When you select "Cancel", the prompt reappears.  If you continually select "Cancel" or hold down the escape key, the password prompt will eventually go away.

This problem is caused by the interaction of Excel with other software packages.  It is not caused by the SPC for Excel software.  Our software does have a password, but it is not needed to run the program. The password prompt can be caused by other Excel add-ins.   But there are three party software providers that cause the problem as well.  Jon Peltier has put together a list of third-party software providers known to cause this problem:

  • Dropbox (note: turning off Dropbox Badge prevents the problem from occurring)
  • Adobe Acrobat
  • Acrobat PDFMaker (reported fixed in December 2013)
  • ProjectWise
  • Palo
  • Hyperion SmartView
  • Tabs for Excel
  • Microstrategy
  • OmniJoin
  • CapitalIQ
  • ManicTime

If you have one of these programs, please try closing the program and see if the problem persists. 

FIshbone or FMEA: Error 1004, Description: Excel cannot insert the sheets into the destination workbook ....

You get this error when you have the option set to save workbooks as .xls (Excel 2003 and earlier format).  This option needs to be set to save workbooks as .xlsx (Excel 2007 and later).  Excel 2003 and earlier have fewer rows in a workbook than Excel 2007 and later.  This is what causes the error.  To correct this, do the following:

  • For Excel 2007, select the Office button in the upper left hand corner and then Excel Options
  • For Excel 2010 and later, select File and Options
  • Select Save
  • Change “Save files in this format” to “Excel Workbook (“xlsx”)”
  • Select OK

Close and then re-open Excel. 

 "The files are corrupted" message

Some users have reported getting this message when trying to download the software. The downloaded version should be about 17 MB in size. If you get this message and right click on the downloaded file, it will probably be about 600KB in size.
If this is the case, your anti-virus program is most likely stopping the download of the software. The software in written using Visual Basic for Applications. Some anti-virus programs pick this code up as a possible source of a virus. You can download the software by turning off your anti-virus program and then turning it back when you have download the software.  You can also try to Run instead of Save the program when installing the software

System error &H80004005, unspecified error

This is not a problem with the software.  It is a problem with the installation of Office.   If you get this error, please run Repair Office.  This usually corrects the error.  However, sometimes the error is due to an EXD file that is present.  Run the free Temp File Deleter, which can be downloaded by clicking here.  Running this deletes all temp files and all the EXD files.  For more details on this issue please see Bob Flanagan’s webpage.  This webpage discusses how to solve issues that interfere with Excel add-ins by version of Excel.

spcupdatesettlings.xlam is read only

This error occurs on some setups of Windows 7 when the SPC for Excel are installed in the "Program Files" folder.  It is a read/write permission issues.  The easiest solution is to re-install the software in a different folder. 

Connect with Us

SPC Knowledge Base Sign-up

Click here to sign up for our FREE monthly publication, featuring SPC and other statistical topics, case studies and more!

SPC Around the World

SPC for Excel is used in over 60 countries internationally.  Click here for a list of those countries.