Excel未更新单元格，选项>公式>工作簿计算设置为自动 [英] Excel is not updating cells, options > formula > workbook calculation set to automatic
问题描述
此问题的通常答案是将公式转换为自动的.就我而言，这是行不通的.
The usual answer to this question is to turn formulas to automatic. This, in my case, is not working.
第二个常见答案是有些宏会影响Excel设置.我的问题(xlsx文件)不是这种情况.
The second usual answer is that there is some macro that is affecting the Excel settings. This is not the case with my problem (xlsx file).
Office 2010，我的简单公式没有更新.
Office 2010, my simple formula is not updating.
公式为:
=IFERROR(TRIM(OFFSET(MainCopy!AG$3,$A77,0)),"")
电子表格中的所有其他内容都在更新. MainCopy中的单元格具有正确的值.显示的值是我更新MainCopy信息之前的值.当我在MainCopy中添加新信息时，此页面上的值保持不变.
Everything else is updating in the spreadsheet. The cell in MainCopy has the correct value. The value displayed is the value before I updated the information on MainCopy. When I put new information in MainCopy, the value on this page stayed the same.
我有:
- 在互联网上研究了此问题-容易找到的所有解决方案都不能解决该问题
- 按下F9键(不执行任何操作)
- 按下Shift-F9键(不执行任何操作)
- 将计算转换为手动，并击中F9的所有组合(什么都不做)
- 将计算恢复为自动(不执行任何操作)
- 以新名称保存(没有做任何事情)
- 重新更新MainCopy上的数据(没有做任何事情)
- 选择单元格并按F9键(不执行任何操作)
- 将光标放在框中，然后按Enter(正确更新值)
我不能将光标放在每个框中，然后按Enter，框太多了.另外，这正在电子表格中创建一个主要的错误陷阱，需要正确.此文件中是否触发了一些晦涩难懂的设置，从而造成了此问题?
I cannot put my cursor in each box and hit enter, there are too many boxes. In addition, this is creating a major error trap in a spreadsheet that needs to be correct. Is there some obscure setting that has been triggered in this file that is creating this issue?
推荐答案
我今天在工作表中遇到了这种情况. F9和打开迭代计算"都不会更新所讨论的单元格，但双击该单元格并按Enter即可.我搜索了Excel帮助，并在标题为更改公式的重新计算，迭代或精度的帮助文章中找到了它:
I had this happen in a worksheet today. Neither F9 nor turning on Iterative Calculation made the cells in question update, but double-clicking the cell and pressing Enter did. I searched the Excel Help and found this in the help article titled Change formula recalculation, iteration, or precision:
- Ctrl Alt F9 :
- 重新计算所有打开的工作簿中的所有公式，无论自上次重新计算以来是否已更改.
- Ctrl Shift Alt F9 :
- 检查相关公式，然后重新计算所有打开的工作簿中的所有公式，无论自上次重新计算以来是否已更改.
- CtrlAltF9:
- Recalculate all formulas in all open workbooks, regardless of whether they have changed since the last recalculation.
- CtrlShiftAltF9:
- Check dependent formulas, and then recalculate all formulas in all open workbooks, regardless of whether they have changed since the last recalculation.
所以我尝试了 Ctrl Shift Alt F9 ，当然，我所有的非重新计算公式终于重新计算了！
So I tried CtrlShiftAltF9, and sure enough, all of my non-recalculating formulas finally recalculated!
这篇关于Excel未更新单元格，选项>公式>工作簿计算设置为自动的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
