You might have seen multiple times that whenever you edit something, excel goes into a non responsive mode and after some time it comes back to life 🙂

Below things may help you to resolve this

1) Disable Auto Complete/Auto Flash fill feature by going to File -> Options -> Advanced -> Uncheck autocomplete for cell values

2) Change Workbook calculation from Automatic to Manual mode by going to File -> Options -> Formulas -> Change Automatic to Manual.
This will result excel to stop calculating formulas automatically so keep in mind to do a refresh of formulas by pressing F9.

Advertisements