Thank God for screengrabs, otherwise this would be just like when you bring your car to the mechanic because it's making a noise that it stops making as soon as you pull up to the garage.

There was nothing special about the find all, as you can see from the one that works. However, I tried what's worked in the past, which was to copy the entire sheet and past it into a new sheet, and that appears to have alleviated the issue.

You will hear from me again if it happens again. Otherwise, cheers!