excel freezes while entering data

Question

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.

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.

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

Any ideas?

Answer 1

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

Answer 2

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