Microsoft Excel在大多数情况下往往运行良好,但有时它会出现问题,甚至无法执行基本任务。例如,最近有些人一直在抱怨无法正确启动Excel。这些人有一个相当奇怪但共同的经历。当他们尝试使用Excel启动文件时,该工具会显示一个空白屏幕(blank white screen),那么这里发生了什么?
根据我们收集到的信息,该问题仅在用户双击文件以打开它时出现。每当他们使用File > Open > Workbook时,Excel文件都会毫无问题地打开,但由于双击速度要快得多,我们不能告诉用户只满足于更难的处理方式。
Excel打开一个空白工作表(Blank Sheet)而不是文件
您看到空白屏幕的原因可能还有其他原因,因此希望我们将要讨论的技巧都能正常工作。如果您的Excel电子表格文件打开,但除了空白屏幕外不显示任何内容,则您需要执行以下操作来解决此问题。
- 关闭(Turn)硬件图形加速(Hardware Graphics Acceleration)
- 将 Excel(Set Excel)文件关联设置为默认值
- 忽略 DDE
- 修复微软办公室
让我们以更详细的格式来看看这个。
1]关闭(Turn)硬件图形加速(Hardware Graphics Acceleration)
您要做的第一件事是打开Microsoft Excel,然后导航到文件(File)>选项(Options)>高级(Advanced)。从那里向下滚动以找到“显示”(Display)部分,然后在其下选择“禁用硬件图形加速(Disable hardware graphics acceleration)”框。
最后,单击窗口底部的“确定”,然后检查是否一切正常。(OK)
阅读(Read):Microsoft Excel 提示和技巧(Microsoft Excel Tips and Tricks)。
2]将Excel(Set Excel)文件关联设置为默认
重置文件关联并不难,所以让我们看看如何轻松完成这项工作。
好的,所以我们需要通过单击Windows 键(Windows key)+ I来启动(I)设置(Settings)区域。
设置(Settings)应用程序启动并运行后,从菜单中选择应用程序(Apps),然后导航到默认应用程序(Default Apps)>按应用程序设置默认值(Set defaults by app)。从那里,单击Excel并确定关联。
您现在应该会看到尝试查找您的程序的搜索过程。在列表中看到 Excel 后,选择它,然后单击为此程序选择默认值。(Choose)
从那里,将出现关联屏幕,所以当它出现时,请单击Select All > Save > OK,就是这样。
阅读(Read):如何使用 Excel 设计简单的平面图。(How to use Excel to design simple Floor Plans.)
3]忽略DDE
根据我们的经验,有可能会启用忽略使用动态数据交换(Dynamic Data Exchange)的应用程序的功能。至少从我们的角度来看,最好的选择是关闭它,那么我们该怎么做呢?
在讨论这个之前,我们应该指出,DDE的功能是在用户启动双击时向程序发送消息。该消息告诉文件打开,所以如果这被忽略,那么就会出现问题。
要解决此问题,请打开Excel,然后导航到File > Options > Advanced > General,然后找到显示Ignore other applications that use Dynamic Data Exchange ( DDE ) 的部分并取消选中该框。单击确定(OK)按钮完成任务。
4]修复微软Office
如果所有其他选项都失败,那么我们建议修复Microsoft Office。您需要返回控制面板(Control Panel),然后选择程序(Programs)>卸载程序(Uninstall Programs)> Microsoft Office,然后单击更改(Change)。最后,选择Online Repair,然后单击Repair并等待它完成任务。
让我们知道这里是否对您有所帮助。
Microsoft Excel opens a Blank Sheet instead of the file
Microsoft Excel, for the most part, tends to work well, but there are times when it buckles and fails to perform even basic tasks. For example, some folks have been complaining as of late about the inability to launch Excel properly. These folks are having a rather strange, but common experience. When they attempt to launch a file using Excel, the tool shows a blank white screen instead, so what’s going on here?
From what we’ve gathered, the issue only appears when the user double-clicks a file to open it. Whenever they use File > Open > Workbook, the Excel file opens without problems, but seeing as double-clicking is much faster, we cannot tell users to just settle for the harder way of doing things.
Excel opens a Blank Sheet instead of the file
There may be other reasons why you’re seeing a blank screen, so hopefully, the tips we’re going to discuss will work all the same. If your Excel spreadsheet file opens, but does not display anything except a blank screen, here’s what you need to do to fix the issue.
- Turn off Hardware Graphics Acceleration
- Set Excel file associations to default
- Ignore DDE
- Repair Microsoft Office
Let us look at this in a more detailed format.
1] Turn off Hardware Graphics Acceleration
The first thing you’ll want to do is open Microsoft Excel, then navigate to File > Options > Advanced. From there, scroll down to locate the Display section, and under it, select the box that says Disable hardware graphics acceleration.
Finally, click OK at the bottom of the window and then check if things are working as they should.
Read: Microsoft Excel Tips and Tricks.
2] Set Excel file associations to default
Resetting file associations is not difficult, so let’s look at how we can get this done with ease.
OK, so we need to fire up the Settings area by clicking on the Windows key + I.
Once the Settings app is up and running, select Apps from the menu, then navigate to Default Apps > Set defaults by app. From there, click on Excel and decide the associations.
You should now see the search process attempting to find your programs. Once you see Excel on the list, select it then click on Choose default for this program.
From there, the association screen will appear, so when it does, please click on Select All > Save > OK, and that’s it.
Read: How to use Excel to design simple Floor Plans.
3] Ignore DDE
From our experience, there is a chance the ability to ignore applications that use Dynamic Data Exchange is turned on. The best option, at least from our point of view, is to turn it off, so how can we do that, then?
Before we talk about that, we should point out that the function of DDE is to send messages to a program once the user initiates a double-click. The message tells the file to open, so if this is being ignored, then problems will arise.
To solve the issue, open Excel, then navigate to File > Options > Advanced > General, then locate the section that says Ignore other applications that use Dynamic Data Exchange (DDE) and uncheck the box. Click the OK button to complete the task.
4] Repair Microsoft Office
Should all other options fail, then we recommend repairing Microsoft Office. You will need to return to the Control Panel, then select Programs > Uninstall Programs > Microsoft Office, then click on Change. Finally, select Online Repair, and complete with clicking Repair and wait for it to finish the task.
Let us know if anything here helped you.