Pages

Thursday, November 10, 2016

Three Most Common Excel Issues and their Solutions

Summary: In this article, I will discuss three MS Excel errors and their solutions by the smart way. These are very simple tips that explain how a user can leverage Excel problems.

MS Excel is a useful application for the home user as well as the business user. It plays an important role differently on different sectors. A school teacher can use it to maintain student records where a data analyst can use the function and formulas to find the appropriate output. Three common errors that I will describe in this blog are:
  • Excel file is corrupted and cannot be opened
  • Microsoft Excel is not responding
  • Unable to save Excel file (User issue)
These errors can occur in MS Excel 2016, 2013,2010, 2007, etc. Let’s discuss them.
  • Excel file is corrupted and cannot be opened
This error message also Occurs in so many Excel version including MS Excel 2016. Users complain that when they update their MS Office (example: from 2007 to 2010) then got this error. User can fix this error by following ways
  1. Change the protected view setting: When a user upgrades the MS office then, changes in protected view setting has occurred by default. User need to change the setting back to solve this problem and to do so:
    1. Go to File-> Options.
    2. In Excel Options window, Choose Trust Center option.
    3. Click on Trust Center Setting button.
    4. Now select the Protected View option. Uncheck all the options and click OK.
  1. Change the component service setting: Follow the steps
    1. Open run command prompt (Press Windows + R) and type dcomcnfg and click OK.
    1. Now, a user can see three portions. Double click on computer folder which is located in the middle section. In My Computer logo, click right and select Properties.
    2. Go to Default Properties tab; tick marks the Enable Distributed COM on this computer. Set the Default Authentication level as Connect and Default Impersonation Level as Identify. Click OK. See the image below
  • Microsoft Excel is not responding error
This error message is also very frustrating for MS Excel User. Suddenly, Excel works slow and show the not responding message. User can solve the error by following methods:
  1. Change default printer: The question must be, how can change in default printer setting fix this problem? When a user opens the MS Excel file then, application tries to communicate with the printer to figure out the margins supported by default printer. Excel crashes when communication fails. Change the default printer by following steps:
    1. Open Control Panel.
    2. In Hardware and Sound section, click on View devices and printers.
    1. Choose the printer, right-click on it and select Set as default printer option. For example, right click on “Microsoft XPS Document Writer” and make it default printer.
  1. Excel in safe mode: Add-ins became disabled in safe mode. Press Windows+R key to open command prompt. Type Excel.exe /safe to open excel file in safe mode. After opening in safe mode follow these steps:
    1. Go to File tab-> Options.
    2. Select Add-ins.
    3. Select COM Add-ins and click on GO button.
    1. Uncheck them and click on OK button.
  1. Repair MS Office: Repairing MS Office is more solution for this error. Only follow these steps:
    1. Open Control Panel.
    2. In Programs section, click on Uninstall a program link.
    3. Select the Office program the list, right-click on it and select change option.
    4. Select the radio button for Repair option and press Continue.

  • Unable to save excel file: There are several reasons behind this error like; user right, drive space issue, lost connection, confliction with an anti-virus program, shared Excel file, path limitation and, Excel file template with embedded objects, etc. Methods to fix this problem are:
    1. Save the file by new name: try this
      • Open Excel file.
      • Select Save As option.
      • Save the file by using a unique name.
      • Open the new file.
    2. Save the file in HTML format: Repeat the three steps of the above solution but, select file type as Web Page. By this method, a user can retrieve the data of the file.
    3. Change the file location: Change the file location and open it from the new location.

One common solution these three problems

There is a common solution to fix these errors. Stellar Phoenix Excel Repair is a third party Excel Repair software. It can fix these errors in a secure manner. The user can try the free demonstration of this tool.

The bottom line: I described the standard solutions of these three most common Microsoft Excel errors. At last a tool for the same. I hope the user can fix them by using these methods and they won’t be a nightmare. Comments and suggestions are accepted.

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...