Excel locks/freezes after using find and replace

%3CLINGO-SUB%20id%3D%22lingo-sub-1976132%22%20slang%3D%22en-US%22%3EExcel%20locks%2Ffreezes%20after%20using%20find%20and%20replace%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1976132%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20i%20currenlty%20have%20a%20major%20issue%20concerning%20excel%20and%20i%20can't%20find%20any%20valuable%20documentation%20about%20that%20issue.%20The%20idea%20is%20simple%2C%20whenever%20i%20use%20the%20find%20and%20replace%20option%20on%20my%20excel%20table%2C%20where%20there%20are%20between%201000%20and%2010000%20cells%2C%20it%20changes%20exaclty%20what%20i%20want%20in%20a%20fraction%20of%20a%20second%20but%20after%20that%20excel%20freezes%20completly%20even%20freezing%20the%20entire%20computer%20for%20multiple%20minutes.%20My%20computer%20is%20powerfull%20that's%20not%20the%20problem%20(i%20did%20the%20same%20on%20really%20simple%20computer%20where%20i%20only%20takes%20few%20secondes%20to%20do%20my%20task).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20help%2C%20if%20you%20have%20any%20idea%20that%20could%20save%20my%20thesis%20i%20would%20be%20gratefull.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1976132%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi, i currenlty have a major issue concerning excel and i can't find any valuable documentation about that issue. The idea is simple, whenever i use the find and replace option on my excel table, where there are between 1000 and 10000 cells, it changes exaclty what i want in a fraction of a second but after that excel freezes completly even freezing the entire computer for multiple minutes. My computer is powerfull that's not the problem (i did the same on really simple computer where i only takes few secondes to do my task).

 

Thanks for your help, if you have any idea that could save my thesis i would be gratefull.

1 Reply

@ZeMostWanted 

Sounds like your data might have gotten corrupted. Make a copy of the file and give this a go:

 

Repair a corrupted workbook - Excel (microsoft.com)