5 Excel Troubleshooting Tips

Having excel trouble and looking for 5 excel troubleshooting tips? Microsoft Excel is a powerful spreadsheet program that can perform numerous accounting and mathematical functions and can even serve as a small database. Being a software program however, Excel does suffer from occasional glitches and bugs that can cause frustration to the user of this program. Here are five common troubleshooting tips for the Excel user to try before calling support.

  1. Disable Excel Add-ins. Like many programs, Excel add-ins are installed to promote additional functionality to the Excel program itself. Sometimes these add-ins can cause problems. To disable the excel add-ins click on the "Office" button > Excel Options and select "Add-Ins." If you are using Excel 2000-2003 go to the "Tools" menu and select "Add-Ins." You can disable the add-ins one by one to find out which one is corrupt or you can disable them all and add them in one by one until the problem re-occurs.
  2. Let Excel fix itself. MS Excel 2003 and 2007 have the option of running their own repairs. This feature is called, detect and repair. In Excel 2003 select help > detect and repair > start.  In Excel 2007 click on the office button > Excel Options > resources > diagnose and then click "Continue." Click the "Start Diagnostics" button. This will start a detect and repair operation within Excel to find and resolve the problem.
  3. Modify the macro security settings. Sometimes Excel refuses to open a document because it has a macro and the Excel macro settings are set too low for it to open. You can modify these temporarily to open the file. In Excel 2007 start at the office button > excel options > trust center. Click on trust center settings and then choose the macro settings level you desire. You can alternate through these to find the setting that will allow Excel to open the file. Make sure not to leave this in too low a setting or your computer can be opened to unwanted risks.
  4. Reboot the computer or restart Excel. Often the simple solution will elude us as can be the case with many different programs. If you run into a problem with Excel, close out Excel and restart it. Make sure that your data and or information has been saved prior to doing this to avoid losing work. If restarting Excel does not solve the program then close out of all programs and reboot the computer. Ask anyone that has done technical support and they will amaze you with how many times this works.
  5. Remove and install Excel. When all else fails sometimes there is a need to remove the excel program and install it over. Make sure, before removing Excel that you have the original Excel or MS Office disk that was installed to make sure you can install it again. Normally you can remove Excel from the add remove programs options in the control panel of Windows. To install, simply place the Excel or Office disk into the computer and the auto run feature should take over and allow you to install.

Using some of these simple tips for troubleshooting Excel can save a lot of time and frustration. These tips will also work for a number of MS Office applications as well.

show comments

What Others Are Reading Right Now.