Your mileage may vary on this next suggestion, but as the file is pretty big, there's nothing to stop you from converting the formulas into permanent "yes/no" answers in the sections of your data where you know the answer really is permanent, where there's no chance of a "no" changing to a "yes" were more lines added...

So, on the portions of your 25000 rows, highlight the yes/no flags, copy, then Edit > Paste Special > Values back over the top of it, and now the yes/no is permanent on those cells.

===============
Other than that If your issue is resolved, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED]