I am trying to run a "find" (ctrl-f) on a worksheet with about 3000 line items. When i type in the "find what" criteria and hit "find next", excel take about 30 seconds to locate the item.

The same search is usually almost instantaneous.

I have spent the better part of this morning searching online and this forum for an answer but i have not been able to find anything to help.

Any help is greatly appreciated.