Microsoft Excel已停止工作 [英] Microsoft Excel has stopped working

查看:615
本文介绍了Microsoft Excel已停止工作的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

每当我使用箭头键向下滚动时,Excel都会停止工作:





我得到这个:



解决方案

要快速排除excel本身的问题,请输入运行对话框(Winkey + R) - excel / a 。这对于COM来说是非常好的,意味着没有自定义的excel。您的错误现在发生了。



获取错误详细信息。在设置中搜索查看问题详细信息。右键单击您的错误,然后选择查看技术细节。发布这些。



它将看起来像这样。

 描述
导致此程序停止与Windows进行交互的问题。
应用程序路径错误:C:\Program Files\Internet Explorer\iexplore.exe

问题签名
问题事件名称:AppHangXProcB1
应用程序名称:iexplore .exe
应用程序版本:11.0.10240.16412
应用程序时间戳:55b99d3f
挂号:d229
挂起类型:134742048
等待应用程序名称:iexplore.exe
等待申请版本:11.0.10240.16412
操作系统版本:10.0.10240.2.0.0.768.101
区域设置ID:3081
附加挂号1:d2293b30a82e02c1d065885655e2fc11
附加挂号2 :e68d
附加挂号3:e68d7530cc359e253127575d50ba30e2
附加挂号4:d229
附加挂号5:d2293b30a82e02c1d065885655e2fc11
附加挂号6:e68d
附加挂号7 :e68d7530cc359e253127575d50ba30e2

解码错误



- 2147220978样式号是32位有符号整数,用计算器转换为hex =



Windows错误(小数)和COM HResults(通常为
异常,以0x80040154开头的8)在WinError.h中定义,$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $

作为一般规则,Windows错误小于65,535(0xFFFF)。错误=
起始0x80000001是组件对象模型(COM)HResults。错误=
起始0xC0000001是NTStatus结果。从0xD0000001开始的错误是=
也是在HResult中返回的NTStatus值。



NTStatus错误(通常但不总是以C开头,因为=
0xC0000022)在NTStatus.h中定义= 20



.h文件是最好的源代码,因为它包含符号名称=
可以给出的错误线索如错误的来源。 =
FormatMessage不给出符号名称的描述。



您可以通过下载Platform SDK(千兆字节)获取这些文件
< a href =http://www.microsoft.com/en-us/download/details.aspx%3Fid%3D8279&sa=3DU&e= =nofollow> http://www.microsoft.com /en-us/download/details.aspx%3Fid%3D8279&sa=3DU&e=
i = 3Dw2IrULDDLsHFmAWbmIHoBg& ved = 3D0CBwQFjAA& usg = 3DAFQjCNHZn9-4f2NnuN9o3UWU =
sOF3wL7HBQ



如果你只想要这两个文件,我有他们在我的skydrive,所以我可以=
引用他们在任何地方去。
https://skydrive.live.com/redir?resid=3DE2F0CE17A268A4FA!121



注意互联网错误(12,000 - 12,999)是Windows错误,但是在wininet.h中指定的=
也可在上面。 p>

其他.h文件中定义了错误。但是99%是在三=
以上。



HResults和NTStatus代码的结构



HRTSults中最重要的位,NTStatus中两个最重要的位=
设置为错误。因此,Hresults在错误上开始8,=
NTStatus在错误时启动C。接下来的14或15位是保留的,一些=
指定设备 - 错误是什么区域。这是读取十六进制时的第三个和=
第四个数字。 EG 0xnn07nnnn - HResult设施代码=
7是正常的Windows错误(从COM程序返回 - 因此它是=
作为HResult返回)。设备代码在Winerror.h中定义为=
HResults和NTStatus.h用于NTStatus代码。他们是不同的。



解码0x8003nnnn错误



设备代码3的HResults意味着HResult包含OLE Structured =
存储错误(0x0至0xff)。这些与Dos错误代码相同。 =
这些似乎不在Windows的头文件中,代码结束时的代码列表是=



解码0x8004nnnn错误



设备代码4的HResults意味着HResult包含OLE错误(0x0 =
至0x1ff),而其余范围(0x200以上)是component =
具体错误,所以20e从一个组件将具有不同的含义=
到20e来自另一个组件。



这就是为什么错误的来源对于
0x80040200以上的错误是非常重要的。



要解码0x8007nnnn错误 / p>

具有设施代码7的HResults意味着HResult包含Windows'=
错误代码。你必须查找Windows的错误代码而不是HResult。



解码0x80070002。 0x表示它是一个十六进制数字,8 =
表示错误,前7表示Windows错误,其余的
数字2表示实际的Windows错误。



要查找错误,我们需要十进制格式。开始计算器=
(开始 - 所有程序 - 附件 - 计算器)并选择查看菜单 - =
科学,然后查看菜单 - 十六进制。输入2.然后查看菜单 - 十进制。 It =
将会说2。



启动命令提示符(开始 - 所有程序 - 附件 - 命令=
提示符)并键入



net helpmsg 2



它会说



系统无法找到指定的文件。



或查找winerror.h

  // 
// MessageId:ERROR_FILE_NOT_FOUND
//
// MessageText:
//
//系统找不到指定的文件。
//
#define ERROR_FILE_NOT_FOUND 2L

解码0x8019nnnn错误



设施0x19的HResults是HTTP错误。 16,384(0x4000)=
下的代码与HTTP错误相同,例如HTTP状态404:服务器上不存在请求的URL =
是0x80190194(0x194 = 3D 404)。



要解码0xDnnnnnnnn错误



启动0​​xD的HResults是一个具有NTStatus值的HResult。 Just =
将主导D放到C并作为NTStatus处理(Hresult = 3D NTStatus =
OR 10000000)。


Whenever I use the arrow key to scroll down, Excel stops working:

And I get this:

解决方案

To quickly rule out problems with excel itself, type in run dialog (Winkey + R) - excel /a. This starts excel for COM and means no customisation of excel. Does your error occur now.

Get the error details. In settings search for View Problem Details. Right click your error and choose View Technical Details. Post those here.

It will look something like this.

Description
A problem caused this program to stop interacting with Windows.
Faulting Application Path:  C:\Program Files\Internet Explorer\iexplore.exe

Problem signature
Problem Event Name: AppHangXProcB1
Application Name:   iexplore.exe
Application Version:    11.0.10240.16412
Application Timestamp:  55b99d3f
Hang Signature: d229
Hang Type:  134742048
Waiting on Application Name:    iexplore.exe
Waiting on Application Version: 11.0.10240.16412
OS Version: 10.0.10240.2.0.0.768.101
Locale ID:  3081
Additional Hang Signature 1:    d2293b30a82e02c1d065885655e2fc11
Additional Hang Signature 2:    e68d
Additional Hang Signature 3:    e68d7530cc359e253127575d50ba30e2
Additional Hang Signature 4:    d229
Additional Hang Signature 5:    d2293b30a82e02c1d065885655e2fc11
Additional Hang Signature 6:    e68d
Additional Hang Signature 7:    e68d7530cc359e253127575d50ba30e2

Decoding Errors

-2147220978 style numbers are 32 bit signed integers, convert to hex = with calculator.

Windows errors (smallish numbers) and COM HResults (typically, but with = exceptions, start with an 8 as in 0x80040154) are defined in WinError.h, = except 8007nnnn where you look up the Window error number that it = contains.

As a general rule Windows errors are less than 65,535 (0xFFFF). Errors = starting 0x80000001 are Component Object Model (COM) HResults. Errors = starting 0xC0000001 are NTStatus results. Errors starting 0xD0000001 are = also NTStatus values returned in a HResult.

NTStatus errors (typically but not always start with an C as in = 0xC0000022) are defined in NTStatus.h.=20

.h files are the best source because it includes the symbolic name of = the error which can give clues such as the source of the error. = FormatMessage doesn't give the symbolic name only the description.

You get these files by downloading the Platform SDK (it's gigabytes) http://www.microsoft.com/en-us/download/details.aspx%3Fid%3D8279&sa=3DU&e= i=3Dw2IrULDDLsHFmAWbmIHoBg&ved=3D0CBwQFjAA&usg=3DAFQjCNHZn9-4f2NnuN9o3UWU= sOF3wL7HBQ

If you just want the two files I have them on my skydrive so I can = reference them anywhere I go. https://skydrive.live.com/redir?resid=3DE2F0CE17A268A4FA!121

Note internet errors (12,000 - 12,999) are windows errors but are = specified in wininet.h also available above.=20

There are errors defined in other .h files. But 99% are in the three = above.

Structure of HResults and NTStatus Codes

The most significant bit in HResults, and the two most significant bits = in NTStatus are set on error. Hence Hresults start 8 on error and = NTStatus starts C on Error. The next 14 or 15 bits are reserved and some = specify the facility - what area the error is in. This is the third and = fourth number when reading hex. EG 0xnn07nnnn - An HResult facility code = 7 is a normal Windows' error (returned from a COM program - hence it's = returned as a HResult). Facility codes are defined in Winerror.h for = HResults and NTStatus.h for NTStatus codes. They are different.

To Decode 0x8003nnnn Errors

HResults with facility code 3 means the HResult contains OLE Structured = Storage errors (0x0 to 0xff). These are the same as Dos error codes. = These don't seem to be in Windows' header files and the list of codes is = at the end of this post.

To Decode 0x8004nnnn Errors

HResults with facility code 4 means the HResult contains OLE errors (0x0 = to 0x1ff) while the rest of the range (0x200 onwards) is component = specific errors so 20e from one component will have a different meaning = to 20e from another component.

This is why the source of the error is extra important for errors above = 0x80040200.

To Decode 0x8007nnnn Errors

HResults with facility code 7 means the HResult contains a Windows' = error code. You have to look up the Windows' error code not the HResult.

To decode 0x80070002. The 0x means it's a hexadecimal number, the 8 = means error, the first 7 means it a windows error, and the rest of the = number, 2, is the actual Windows error.

To look up the error we need it in decimal format. Start Calculator = (Start - All Programs - Accessories - Calculator) and choose View menu - = Scientific, then View menu - Hex. Enter 2. Then View menu - Decimal. It = will say 2.

Start a Command Prompt (Start - All Programs - Accessories - Command = Prompt) and type

net helpmsg 2

and it will say

The system cannot find the file specified.

or look it up in winerror.h

  //
  // MessageId: ERROR_FILE_NOT_FOUND
  //
  // MessageText:
  //
  // The system cannot find the file specified.
  //
  #define ERROR_FILE_NOT_FOUND             2L

To Decode 0x8019nnnn Errors

HResults with facility 0x19 are HTTP errors. Codes under 16,384 (0x4000) = are the same as HTTP errors, eg HTTP status 404: The requested URL does = not exist on the server is 0x80190194 (0x194 =3D 404). Codes 16,384 and = higher are BITS specific.

To Decode 0xDnnnnnnn Errors

HResults starting 0xD are an HResult with a NTStatus value in it. Just = cange the lead D to a C and treat as an NTStatus (Hresult =3D NTStatus = OR 10000000).

这篇关于Microsoft Excel已停止工作的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆