Excel crash trying to sort large data file

%3CLINGO-SUB%20id%3D%22lingo-sub-2174218%22%20slang%3D%22en-US%22%3EExcel%20crash%20trying%20to%20sort%20large%20data%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2174218%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20file%20that%20has%2030%2C000%20rows%2C%20no%20forumulas%20in%20the%20data%20just%20names%20and%20addresses.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20use%20conditional%20formating%20to%20highlight%20duplicates%20on%20ID%20and%20post%20code.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20i%20click%20on%20data%20sort%20to%20sort%20by%20cell%20colour%20it%20just%20seems%20to%20crash%20all%20the%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20to%20copy%20to%20new%20workbook%20and%20also%20to%20format%20data%20as%20a%20table%20and%20still%20get%20the%20same%20slowness%20and%20crashing%20issues.%3C%2FP%3E%3CP%3EI%20even%20bought%20a%20brand%20new%20laptop%20with%208GB%20memory%20and%20still%20having%20same%20issue.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20checked%20excel%20and%20it%20is%20up%20to%20date%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2174218%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have a file that has 30,000 rows, no forumulas in the data just names and addresses.

 

I use conditional formating to highlight duplicates on ID and post code.

 

When i click on data sort to sort by cell colour it just seems to crash all the time.

 

I have tried to copy to new workbook and also to format data as a table and still get the same slowness and crashing issues.

I even bought a brand new laptop with 8GB memory and still having same issue. 

 

I have checked excel and it is up to date

2 Replies

@ravimistry1 

It is always a good idea to name the Excel version and the operating system in advance.

At the same time, as far as possible (if not always), add your excel workbook / worksheet (without sensitive data) and explain your project / topic / problem related to the file as precisely as possible.

 

Now to your topic:

Since we can only make assumptions here, it would be advantageous if we go step by step from the beginning.

 

Does the problem only occur in this file?

Is the file in Ondrive or Sharepoint? ... Outside (USB, External HDD, CD, etc.) of the laptop?

 

Next, please check whether the Office applications are up to date.

Update Office with Microsoft Update

(click on the link for more information about update)

 

If this didn't help, move on to the next step.

Repair Office from the Control Panel

(press on the link and follow the instructions)

 

For further questions I am gladly at your disposal.

 

If my suggested solution was helpful / liked, please pass it on to the community by clicking on Correct Answer and / or Like. If not, please ignore.

 

Have a nice day.

 

Nikolino

I know that I don't know (Socrates)

@ravimistry1 

How many conditional formatting rules do you have? It shall be not more than number of formatting variants.