Forum Discussion
Excel hangs/freeze after applying conditional formating
Hello , on any/new excel files : after setting up a conditional formatting rule and clicking "OK" - the conditional formatting box turns blank, the "X" is unclickable . - the file remains in th...
Happens when conditional formatting is applied on huge array of data.
Go to Events Viewer (hit the windows key and look for event viewer). Once opened wait for a few seconds (depends) to load all the events. You'll find a tree on the left: Custom Views, Windows Logs, Application and Service Logs etc.
Click on the Application and Service logs. On the Mid-Pane find something related to Microsoft Office and select it. On the Right-Pane select properties.
Click the Clear Log Button. Keep a copy if asked, incase your computer is audited.
Do the same to Windows Logs on the Applications.
See if it helps. If it doesn't, do a repair or re-installation of Office.