vba excel在输入数据时冻结

excel freezes while entering data

提问by Samy Geronymos

I have this excel file and it freezes when I'm entering data. For instance, I double click on a cell, enter the data and when I press " enter ". It freezes instead of going to the cell underneath. Pressing " enter " several times doesn't unfreeze the program, the only thing that works is selecting another cell with the mouse.

我有这个 excel 文件，当我输入数据时它会冻结。例如，我双击一个单元格，输入数据，然后按“回车”。它冻结而不是进入下面的单元格。按“回车”几次不会解冻程序，唯一有效的是用鼠标选择另一个单元格。

This excel sheet has more or less 10 sheets and I have two or three macros but this problem persists even when I'm disabling the macros.

这个 excel 表有或多或少 10 张，我有两个或三个宏，但即使我禁用宏，这个问题仍然存在。

I have tried to run this excel file on two different Macs and both of them experience the same problem.

我试图在两台不同的 Mac 上运行这个 excel 文件，但它们都遇到了同样的问题。

Any ideas?

有任何想法吗？

回答by JohnnyRed

Disable Flash fill under file > options > advanced > editing options > "automatically flash fill" This is a known issue with Excel!

在文件 > 选项 > 高级 > 编辑选项 > “自动快速填充”下禁用快速填充 这是 Excel 的一个已知问题！

回答by Lachlan Duncan

Saving the workbook in an older version enabled me to enter data without the workbook freezing.

以旧版本保存工作簿使我能够在不冻结工作簿的情况下输入数据。

回答by Jimmy

Had the same issue happen to me today. I was editing an Excel workbook that had cells referenced in another workbook that was open at the time. When I entered a value, the worksheet I was on would not respond, going to another worksheet and entering a value then escaping would "reset" and I would be able to go back to the worksheet to resume work, but would get "stuck" again right after entering another value.

今天有同样的问题发生在我身上。我正在编辑一个 Excel 工作簿，该工作簿在当时打开的另一个工作簿中引用了单元格。当我输入一个值时，我所在的工作表不会响应，转到另一个工作表并输入一个值然后转义将“重置”，我将能够返回工作表继续工作，但会“卡住”再次输入另一个值后。

Solved the issue by closing the other Excel workbook that was referencing cells in the workbook I was working on.

通过关闭引用我正在处理的工作簿中的单元格的其他 Excel 工作簿解决了该问题。