Forum Discussion
Excel Crashes on Sorting
Harman365 On a MBP myself. On oldy from 2012. working on a file with 80000+ rows, as many formulae, but minimal formatting with a file size just over 3.5MB. I admit it's not the fastest file but it doesn't hang up Excel. Also on MS365, by the way.
What's in you file? Much (conditional) formatting perhaps or many formulae with INDIRECT or OFFSET? File size?
Riny_van_Eekelen Thanks for your reply. The file is just 1 MB, but yes, I have applied conditional formatting ('highlight duplicate values') on both columns.
Harman365 That should not be a problem. What if you remove the CF and just sort in whatever order. Better then?
Riny_van_Eekelen It works fine if I sort A-Z after removing the CF. But I need to sort after using conditional formatting to highlight duplicates.
Other solutions (such as only sorting a few hundred rows at a time) do not work. To explain better here's come context:
Column_1 is an old list of items
Column _2 is a new list of items
For any non-duplicates, they are either new entries (and must be tagged as such) or deprecated entires (and must be deleted from record).
P.S. I just shifted to using google sheets for the time being, and they work smoothly with the same data file.