+3 votes
270 views
How to fix error opening empty blank sheet Excel 2016

in Office by (552k points)
reopened | 270 views

1 Answer

+4 votes
Best answer

1. How to enable DDE in Excel 2016
2. Modify view types and validate plug-ins Excel 2016
3. How to manage Excel 2016 hardware acceleration
4. How to reset associated files Excel 2016
5. How to use the Office Excel 2016 repair tool

Excel 2016 is a spreadsheet application that offers various options when working with large amounts of data allowing us to have precise control over them thanks to its formulas and functions..

But like any program and application, Excel is not exempt from failing at some time and one of the most common errors currently lies in the detail that when opening a certain file it does not open and we will only see the following:

image

There we are located in the Start menu, but without any worksheet to enter data. This error is often due to some type of blocking generated by Excel since this is not frequent and many times after this environment we will return to normal.

Today we will learn some methods to give a definitive solution to this error in Excel 2016..


1. How to enable DDE in Excel 2016


DDE (Dynamic Data Exchange) is a function present for several years in Excel and its basic operation is to allow the exchange of data between applications of Windows operating systems.
DDE has three types that are DDE, fast DDE and advanced DDE.

Its operation is simple, when we execute a file, in this case speaking of Excel 2016, a DDE message is being sent to Excel to open said file as long as the file extension is compatible (.xls, .xlsx, etc).
A good practice is to validate if DDE is enabled in Excel 2016 and for this we go to File / Options:

image

In the new window displayed we will go to the Advanced section and place the General option; There we must deactivate, or validate that this is the case, Ignore other applications that use Dynamic Data Exchange (DDE):

image

Once this is done, click on OK.


2. Modify view types and validate plug-ins Excel 2016


Excel 2016 offers us various view options for your spreadsheets, and one of them is associated with the possibility of hiding the current spreadsheet with which we will only see a blank file but not its content. To verify this we will go to the View menu, Window group and there validate that the Show option is not active:

image

Although the purpose of the add-ons is to extend the capabilities of the application, in many cases they can be a cause of failures or errors. To check the add-ins in Excel 2016 we go back to the File / Options path and there we will select the Add-ons line:

image

There we will be able to perform a detailed analysis on each complement in order to determine its impact in Excel 2016..


3. How to manage Excel 2016 hardware acceleration


Although the purpose of hardware acceleration is to allow applications to load much faster, sometimes the opposite happens.

In case of presenting this type of errors in Excel 2016, a solution may be to deactivate this functionality. For this, we go to File / options and we go to the Advanced section and we will locate the Show field where we can deactivate the Disable hardware graphic acceleration box:

image

Click OK once the change has been made.


4. How to reset associated files Excel 2016


With this option we can reset the type of extension associated with Excel 2016. For this, in Windows 10, we must go to the next route.
  • Control Panel
  • Programs
  • Default programs

image

There we click on the line Associate a type of file or protocol with a program, and in the window displayed, click on the option Set default values ​​by application:

image

In the new window we select Excel 2016 and click on Manage:

image

We can define what type of extensions will be associated with Excel 2016:

image


5. How to use the Office Excel 2016 repair tool


Microsoft Office includes a tool in its suite which helps us correct errors in the various Office programs.
To make use of it, we go to the Control Panel \ Programs \ Programs and Features path, select the Office application and click on the Change button located at the top, this will display the following window:

image

There we can execute a local repair or an online one according to the need.

With these options we will again have Excel 2016 in optimal conditions of use.


by (3.5m points)
edited

Related questions

+3 votes
1 answer
asked Feb 3, 2023 in Office by backtothefuture (552k points) | 68 views
+5 votes
1 answer
asked Jul 8, 2020 in Office by backtothefuture (552k points) | 227 views
+3 votes
1 answer
asked May 11, 2021 in Windows 10 by backtothefuture (552k points) | 95 views
+3 votes
1 answer
asked Jan 30, 2023 in Office by backtothefuture (552k points) | 77 views
+5 votes
1 answer
asked Sep 16, 2019 in Office by backtothefuture (552k points) | 226 views
Sponsored articles cost $40 per post. You can contact us via Feedback

Most popular questions within the last 30 days

10,659 questions
10,791 answers
510 comments
3 users