Pages

Tuesday, October 18, 2016

How to fix MS Excel blank worksheet issue?

Blank Excel file problem is a very irritating situation. In this case, you will be unable to see the content of the file. Here, I am going to share some solutions to fix this issue.

Before proceeding any methods, try Open and Repair option to fix the issue. when open and repair option not works then, try these options:
  • Copy the file from one location to another location and try to open it. 
  • Rename the file or change the file extension. 
If you are not able to fix the issue by these solutions, then try them:
  1. Ignore Dynamic Data Exchange (DDE): Some applications can interrupt MS Excel to open the worksheet or Excel shows blank worksheet. With DDE option, Excel can share the information with other applications. 
To stop this process, go to File->Options->Advanced. Check the General section and check the “Ignore other applications that use Dynamic Data Exchange (DDE)” and click OK to save the setting.

  1. Check Add-Ins Setting: Turn-off the COM Add-Ins of Excel program.
    1. Open MS Excel
    2. Go to File->Options
    3. Select Add-ins option and, choose COM Add-Ins
    4. Click on Go button
    5. Uncheck them and click OK.

  1. Check File Association: Reset the Excel file association to check the system performance. To do this, follow these steps:
    • For Windows 8
      1. Go to Control Panel
      2. Click on default program->set your default program
      3. Click on Excel, then select choose default for this program
      4. A set program association screen will appear, choose Select All and click on Save.
    • For Windows 7
      1. Open Control Panel and go to Default Programs
      2. Click on Associate a file type or protocol with a specific program
      3. Choose Microsoft Excel Worksheet and the change program
      4. Recommended Program->Microsoft Excel
  2. Repair Office: One solution to fix this issue is, repairing of MS Office program. You can easily do this by following these steps:
    1. Open Control Panel
    2. Click on uninstall the program
    3. Select MS Office from the list
    4. Right click on it and select Change option
    5. Now choose the Repair option and click on Continue button.
  1. Disable Hardware Acceleration: Sometimes, a display issue is also occurred by the hardware graphics acceleration. The symptoms of this interruption are: blurry Office program, Screen flashes, the document not displayed well, Program crashes, reduction in program performance etc. To disable the hardware graphic acceleration in MS Excel, follow these steps:
    1. Go to File->Options->Advanced
    2. Under Display section, “Disable hardware graphic acceleration” option is available. Check the option click on the OK button.

If above options won’t work then, you can give a chance to Stellar Phoenix Excel Repair tool. It is a third-party tool which is able to repair all types of Excel file error.

Conclusion: This blog described the five solutions to fix the blank Excel file issue. It is also possible that, the issue is fixed by either one method or more than one. Close the background process and delete the unwanted Add-Ins from the list for the fast and efficient working of MS Excel.   

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...