Excel find in range causes infinite loop

Question

When searching in the attached sheet for "bs" or "fr" and clicking "find all" there is no problem and excel finds all cells with these words, but when searching for "gr" and clicking "find all", excel goes into infinite loop and keeps counting thousands of cells until I have to abort searching and then the app stops responding and I have to close it from task manager. the sheet is only one page so it's not a huge file. when I move the table to a new file the same thing happens. I tried on another computer and the same thing happened. I even recreated the cells again from scratch by re-typing all the cells in a new file and it still crashes..

Someone kindly explain to me why this bug happens and give me a fix or a way to avoid it

Here is the excel file

Answer 1

This is bug. It seems caused by the value in A46.

After changing it to any other value without "GR", the search function back to normal.

I'd suggest you raise it to Microsoft. Hope it will be fixed soon.

Please contact your admin/IT department create a support ticket via Microsoft 365 Admin Center> Support> New service request.

Get support - Microsoft 365 admin | Microsoft Learn

About how to find the admin in your organization, you can refer to How do I find my Office 365 admin