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...
Sorry -- but I'm not following what the "issue" is, especially from a spreadsheet that isn't the one actually giving you trouble (or am I misinterpreting?).
Are you saying you couldn't get Leila Gharani's teaching example to work on your system? It does work on mine.
Please explain further. Or perhaps post also the copy of your own spreadsheet.
I appreciate your time on this. I have attached a 30 sec video of me trying the file I attached earlier.
I have a large spreadsheet that uses the exact concept Leila produced here. I sent you her copy to make it easier for folks to see.
The drop down button (arrow attached to the cell) for the Data Validation used to trigger a sheet calculation, which would run my formula to conduct the search. Now, I can’t get the Data Validation button to trigger a calculation.
I have attached a small video screen shot of the issue…
Calculation is set to Automatic