@DavidW indeed with your data there seems to be a problem with the evaluation of formulas. On my Mac this also exists with the old Excel writer. If you choose .XLS in the new writer it does work. Not sure if this provides any comfort.
@Iris / @ScottF this might be a problem with the Excel writer