vlookup issues

i created a workbook using excel 2016. when using it on 2007 the vlookup functions do not automatically fill after filling in the drop down choices. i have to save the sheet then reopoen it for every...