Why do you need to reset them ? Doesn't Excel do that automatically ? one example: VLOOKUP. The 4th argument (TRUE or FALSE) forces an Exact match.
So, if you use a formula like
and then, intend to use another VLOOKUP formula like
expecting that Excel would "assume" the False, well, you're in for a big surprise !
I will try to replicate your finding, but, I think this is very strange...