Excel 2016 hanging when changing cell

22 Nov

A couple of users had a rather large Excel file with a single tab but quite a lot of conditional formatting which would hang for 30-60 seconds when you changed any data in a cell and then moved to another cell.

All the usual suspects were checked, all O/S and Office updates applied, remove add-ins, repaired Office etc but the issue was still there.

In the end, the solution was to disable “Automatically Flash Fill” in the advanced options.

You can also do this via policy: