Clicking on the validation list arrow do not update the cells
Excel for mac do not execute formula when you click on the arrow of a validation list, but on the windows it runs normal. It is very important to me.
1 - On the B1 cell put the formula: =A1
2 - Make a list with 2 (or more) items
3 - On the A1 cell, register a validation list with the list created on the step 2
Ok, now, anything you write on the cell A1, will be replicated to B1.
But, when you write something on the A1, and click on the arrow of the validation list, the data on the B1 is not updated.
On the windows os it runs perfectly.
Jeff Sturgeon commented
I'll second this. I have a whole bidding spreadsheet predicated on validation and it won't work now that I updated to 365 16.38. We NEED the validation down arrow to trigger a sheet refresh like it used to in older forms of Excel.