Forum Discussion
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...
mathetes It products the same issue. Must click outside the data validation cell and back into it for the sheet calculation to trigger.
Thanks for looking at this. If you have the exact same issue I have then it might be contributed to the Mac version. The issue doesn't seem to exist on the Windows version.
And I use that functionality in my own expense (budget) tracking sheet, and have never noticed it as a drawback...."when you don't know what you're missing, you don't miss it."