Excel Not Responding when running the Conditional Formatting (Find Duplicates) Tool

Question

Good Morning, I have a lot of problems when after running the find duplicate tools I try and sort by the Cell color function. Now granted, I am trying to sort a list of around anywhere from 30,000 to almost a million products but it has now been running all night and the box to sort by cell color has not progressed. Is there a fix for this? I know if I close out the program and start over it's not going to hurry it up because I've tried that in the past, please help!

Answer 1

I used that response and did as it said and it's still running the same way.

Answer 2

Since you're still having the issue after repairing the Office application, we suggest you download Microsoft Office Configuration Analyzer Tool 2.2 which will highlight known problems that are found when OffCAT scans your computer. You will provide a link to a public-facing article (usually a Microsoft Knowledge Base article) about each problem so that you can read about possible fixes.

Update us with the result.

Answer 3

Hi Stephen,

Dealing with large sets of data may cause Excel not to respond when running the Conditional Formatting Tool to find for duplicates. To fix the issue, you may try to Repair an Office application and check if the issue still persists.

Let us know if you need further help.