Nov 25 2021 02:29 AM
I am running Excel 16.55 on a Macbook Pro '19 with Big Sur 11.6. Yesterday, I installed Microsoft 365 package.
Excel keeps crashing and freezing. Whenever I try to sort by cell color a rather large file (rows>38k, two columns), it freezes. Excel produces an error report when I force quit the program.
I've seen Excel lag in the past, but the performance is very disappointing compared to what one expects from Macbook.
Nov 25 2021 04:34 AM
@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?
Nov 25 2021 04:37 AM
@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.
Nov 25 2021 04:42 AM
@Harman365 That should not be a problem. What if you remove the CF and just sort in whatever order. Better then?
Nov 25 2021 12:21 PM - edited Nov 30 2021 09:46 PM
@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.