Troubleshooting Excel

If you experience issues with Excel, such as non-calculating, crashes etc, try the following:


1. Circular References

This is the most common issue and fixes most calcuation problems.  Keep this setting on at all times.

PC:   Go to File -> Options -> Formulas -> Enable iterative calculation.  Set the maximum iterations to 50 and the Maximum Change to 1.

MAC:  Excel Application -> Excel Menu -> Preferences-> Calculation -> Use iterative calculation.  Set maximum iterations to 50 and Maximum Change to 1.


2. Add-In

To troubleshoot the add in click here .


3. Excel Freezes when using the mouse scroll wheel.

We have found that if you press any button in the panel and then use your mouse wheel before clicking on the spreadsheet, then the page can freeze.  It will sometimes come back if you wait, or you can MAXIMISE any other Window (e.g. a browser) fully over the spreadsheet and then hide it again and the spreadsheet will come back to life.  This is some kind of Windows / Excel bug. 

To avoid this, always click on the spreadsheet before scrolling.


4.  Repair Excel

This may fix some crash issues.

  • Reboot your computer (important!)
  • Right click on the Windows start button, and select Control Panel, Programs and Settings.
  • Find Office and either click on it and then Change up at the top, or right click and select Change.
  • A repair options dialog will appear. There is both a quick repair and an online repair.
  • Do the quick repair, Open Excel and see if all is fixed.
  • If not, close Excel and do the online repair

5.  Microsoft Office Configuration Analyzer Tool

This may fix some crash issues.

Click here to download Microsoft OffCAT Office Scanner. This great tool from Microsoft will help fix your Excel, Word and Outlook programs. Make sure you run the tool repeatedly until you see the message 'No issues detected'. This tool is really worth having regardless.