在引用单元格下面插入一行后，非常简单的公式会崩溃我的程序 [英] Extremely simple formula crashes my program after I insert a line beneath the referenced cell

问题描述

我原来有代码，但现在我删除了该项目中的所有代码。我在sheet1中有一个公式来='Sheet2'！I10。酷，我保存好了。但是，当我在sheet2上插入I​​10以下的那一刻，然后我返回到Sheet1，点击进入公式，不做任何事情，只需按下整个程序崩溃的复选标记。使用APPCRASH报告......为什么

 我的错误报告：
问题事件名称：APPCRASH 
应用程序名称：Excel.EXE 
应用程序版本：14.0.7179.5000 
应用程序时间戳：58a5e2fb 
故障模块名称：EXCEL.EXE 
故障模块版本：14.0.7179.5000 
故障模块时间戳：58a5e2fb 
异常代码：c0000005 
异常偏移量：00261b14 
操作系统版本：6.1.7601.2.1.0.256.48 
区域设置ID：1033 
  

解决方案

所以感谢nqramjets协助我这个问题，我发现主导致这种情况的问题是Windows的安全修补程序，它是 KB3178690 。卸载后，进入控制面板 - >卸载程序 - >在左侧查找&点击查看已安装的更新 - >并在Microsoft Office下找到上述更新号码，然后卸载。

此外，Windows还有一个新的更新，旨在修复这个疯狂错误， - > KB3191855 ，安装此。

此信息可以在Microsoft社区页面上看到，链接如下。

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-msoffice_custom/inserting-a-new-line- under-a-referenced-cell / d4c50c1e-6141-4f6f-b847-6586fe5d23a8 。

再次感谢大家的帮助！
- Googlesoar

I originally had code, but now I deleted all code in that project. I have a formula in sheet1 that goes "='Sheet2'!I10". Cool, I save its ok. But the moment that I insert a line beneath I10 on sheet2 and then I go back to Sheet1 click into the formula and do nothing but press the check mark the entire program crashses. With an APPCRASH report...... WHY

        My Error Report: 
        Problem Event Name:   APPCRASH
        Application Name: Excel.EXE
        Application Version:  14.0.7179.5000
        Application Timestamp:    58a5e2fb
        Fault Module Name:    EXCEL.EXE
        Fault Module Version: 14.0.7179.5000
        Fault Module Timestamp:   58a5e2fb
        Exception Code:   c0000005
        Exception Offset: 00261b14
        OS Version:   6.1.7601.2.1.0.256.48
        Locale ID:    1033

解决方案

So thanks to nqramjets for assisting me on this question I have found that the main problem that caused this was a security patch from windows which is KB3178690. After uninstalling this, go to control panel->Uninstall a program -> on the left find & click view installed updates -> and find the above mentioned update number under Microsoft Office, and uninstall.

Furthermore there is a new update from Windows that is meant to fix this crazy bug, -> KB3191855, install this.

This information can be seen on the Microsoft community page, link below.

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-msoffice_custom/inserting-a-new-line-beneath-a-referenced-cell/d4c50c1e-6141-4f6f-b847-6586fe5d23a8.

Thanks again for everyone's help! - Googlesoar

这篇关于在引用单元格下面插入一行后，非常简单的公式会崩溃我的程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！