Excel on Mac - 16.38 - Drop Down doesn't trigger sheet calculation/formula

Looking for assistance.  Just updated to 365 16.38 from 2011 on a Mac.  I have multiple drop down boxes on a sheet that rely on formulas to allow them to search for characters typed inside them and r...