Fix: Excel data not showing – Excel worksheet area is grayed out (Blank)

One of my customers, faced the following strange problem when he opens several Excel files: The Excel file seem to open normally, but the Excel won’t show the worksheet (Worksheet area is grayed out and the data doesn’t appear at all). As a first try, I repaired the MS Office (2007) installation but the problem still exists. Finally after some research I found the following solution to resolve the “Excel Worksheet data not showing” problem.

How to fix: Excel Data not showing – not visible – data area is grayed out.

1. Go to View Menu and ensure first that the Unhide option is inactive. (otherwise click Unhide and check if you can view the excel data).
2. Select Arrange All.

Excel data not showing - Excel sheet area is grayed out (Blank)

 

3. At the menu that comes up, check the “Windows of active workbook” checkbox and click OK.

image

Now you should see the contents of the Excel Workbook!

4. One last action. Save the Workbook and you ‘re done!

 

Additional help: If the above tip doesn’t help you, then:

A. Perform a repair at Office installation. To do that:

  1. Navigate to Windows Control Panel > Programs and features.
  2. Locate and select the MS Office application and then click Change.
  3. Then select the Repair option.

B. Disable the Hardware Acceleration at Excel application: To do that:

Notice: The option to disable the graphics acceleration is only available at Excel 2010 and Excel 2013.

1. From Excel’s main menu select Options.

excel options

 

2. At Excel Options window, choose Advanced on the left pane.

Excel Advanced Options

3. At the right pane, under Display options, uncheck the “Disable hardware graphics acceleration” checkbox and click OK.

Excel Display Disable hardware graphics acceleration

 

That’s all folks! Did it work for you?

Please leave a comment in the comment section below or even better: like and share this blog post in the social networks to help spread the word about this solution.

If this article was useful for you, please consider supporting us by making a donation. Even $1 can a make a huge difference for us.

Hình ảnh thuộc sở hữu của trang web qnet88.com

Đánh giá post
[related_posts_by_tax posts_per_page="6" title="Bài liên quan" taxonomies="category,post_tag"]

Trả lời

Email của bạn sẽ không được hiển thị công khai. Các trường bắt buộc được đánh dấu *

Hotline: 0974.0707.83(Zalo/Viber)