search file explorer for text inside of a spreadsheet

I have a folder which contains spreadsheets from my vendor. Each one has a list of invoices for a period of time.

I'm trying to search the folder using file explorer for a specific invoice number but there are no search results. To rule out the possibility that the record  doesnt exist because I didn't save that spreadsheet. I opened one and searched for a record which I know exists but it still said "No items match your search".

Also just in case it had anything to do with the search not working, I disabled protected view for files from the internet and potentially unsafe locations

https://medium.com/lets-excel/microsoft-excel-how-to-disable-protected-view-in-ms-excel-ae01a0c5405b#:~:text=%20Steps%20to%20Disable%20Protected%20View%20%201,%E2%80%9CFile%E2%80%9D%20menu%20option%202%20Select%20%E2%80%9COptions%E2%80%9D%20More%20

However I don't know if it needs time to reindex, or how to force a reindex.

[Moved from Excel / Windows 10 / Microsoft 365 Apps or Office 365 Business]