seems like the new Excel Writer is having problems with the evaluate Formula option. Always getting the error: Execute failed: Row 0 has been flushed, cannot evaluate all cells.
When I try to do the same with the deprecated Excel writer everything works fine.
@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.