Hello.

We work with a large excel file (about 27,000 rows total) and have used the "find" function to "get around" on the spreadsheet for a long time with no problem. But now, all of a sudden, the find function takes a very long time to find data. Whereas it used to take 2 seconds, it can take 30 seconds now. Does anyone know what may have happened and how I can fix the problem? I have already tried unsharing the workbook, blocking macros, and checking to see whether excel recognizes that the last cell in the workbook is on the 27,000th line (by pressing Ctrl+ End). Thanks!