Oh, forgot to ask: are you still using Excel 2007? If you have upgraded to 365, the formula can be made to spill.

If you have upgraded, please update your profile.