On my MS query. Can any one explain why when I look within the External Data Properties dialog box it seems to have a shorter list than normal and the option to tick the box so that adjacent formula automatically populate is not visable. The functional ability seems to have gone with his query.