Find tool is very slow

[alex_345]

Hi there,
Looking for some advice on this.

I have a workbook which is used amongst my team on Excel Web, we frequently use the Find tool (CTRL+F) to search for specific rows. In the last weeks, this tool has gotten extremely slow; when pressing enter or clicking 'Find next'/'Find all' for a search term (which is typically a 7 digit #), we seem to have to try many, many times before it goes to the applicable cell(s).

For some background, there are 4 sheets in the workbook, the main sheet is where we mainly use the Find tool, but it's slow on all sheets. One sheet has raw text data. The main sheet has ~12,000 rows of data, each row has a XLOOKUP, date calculation, and copied data from another sheet (='Sheet2'!A101), plus conditional formatting. Another sheet has a sort and filter for the main sheet data.

Not sure if the sheet has gotten too large or if there is something else causing this dreadful difficulty finding data.

ISP 2025.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Order	Phone	Name	Article	Email	LOCATION	Delivery	Arrived	EmailSent	ArrivalDate	DaysOnSite	DatePickedUp	TimePickedUp	Outfitter	Refunds (no tax)	Notes	RowID
2	0	--	0	0	0		0	HAS NOT ARVD			45635						3
3	0	--	0	0	0		0	HAS NOT ARVD			45635						4
Info

Cell Formulas
Range	Formula
A2:A3	A2	='Batch 16'!P3
B2:B3	B2	='Batch 16'!L3
C2:C3	C2	='Batch 16'!J3
D2:D3	D2	='Batch 16'!D3
E2:E3	E2	='Batch 16'!M3
F2:F3	F2	=IFERROR(IF(XLOOKUP(G2,'Scan Here'!$B:$B,'Scan Here'!$E:$E,"",0)=0,"",XLOOKUP(G2,'Scan Here'!$B:$B,'Scan Here'!$E:$E,,0)),"")
G2:G3	G2	='Batch 16'!C3
H2:H3	H2	=XLOOKUP(G2,'Scan Here'!$B:$B,'Scan Here'!$C:$C,"HAS NOT ARVD",0)
K2:K3	K2	=TODAY()-J2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A:G,I:J,L:N	Expression	=($I1="")*(OR($H1="Arrived",$J1<>""))	text	NO
L:L,P:P	Expression	=SEARCH("CAB Refund", $L1)	text	YES
L:L,P:P	Expression	=SEARCH("Refund", $L1)	text	NO
L:L,P:P	Expression	=SEARCH("Cancelled", $L1)	text	NO
L:L,P:P	Expression	=SEARCH("Missing", $L1)	text	NO
K2:K15499,O2:O15499	Cell Value	>40	text	NO
K2:K15499,O2:O15499	Cell Value	between 0 and 20	text	NO
K2:K15499,O2:O105499	Cell Value	>20	text	NO
H2:H105499	Cell Value	contains "ARRIVED"	text	NO
H2:H105499	Cell Value	contains "NOT"	text	NO

Cells with Data Validation
Cell	Allow	Criteria
F1:F3	Any value

 

[Logit]

Conditional formatting, especially on 12,000 rows, is slowing down your workbook. If you determine a means of eliminating the conditional formatting,
the speed will pick up.

 

[alex_345]

Thanks for the suggestion, @Logit, I didn't think of that. I will see if I can reduce the conditional formatting rules or have them stop when true and see how that plays out.