Try closing and re-opening the workbook after you've ticked the box.